Categories

Main
Database
Java
Microsoft.NET
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
ColdFusion
Crystal Reports
Delphi, C etc
JAVA
Microsoft.NET
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
XML & XSLT
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
Applications & Tools
Database Concepts & Design
EJB programming & troubleshooting
EJB design
General J2EE
XML & Web services
Web tier: servlets, JSP, Web frameworks
Performance and scalability
Industry news
TSS feedback
Mobicents Contributors
Mobicents Users
JSLEE Resource Adaptor Types
Planning JavaOne 2008
Sun Tech Days
Other Java conferences
Binary Web Services and XML
Metro and JAXB
GlassFish
GlassFish Plugins
Project jMaki
GlassFish WebTier
Mural
Java Development Tools
Java WS & XML Community News
JAXP
Java SE
6uN Early Access
Java Quick Starter
Java SE Snapshots: Project Feedback
JCK Forum
Feedback and Suggestions
JDK Distros
JDK Open Source
General JSR Discussion
JCP 2.6
JXTA Community Forum
ME Interest
ME Cool Apps
ME General Help
ME Feedback & Suggestions
ME Application Developer Interest
Blu-ray Disc Java
ME Developer Days
Squawk
Mobile Developer Alliance
OpenCable
LWUIT
JavaFX Script Language Discussion
OpenJFX General Discussion
Scene Graph
General Performance Discussion
Your Java Career
NetBeans 6.0
Servlets
JSP
JSF
Portals and Portlets
EJB and Other Java EE Technologies
Distributed Java
Object Relational Mapping
JDBC
Web Services
Swing / AWT / SWT / JFace
JNLP and Web Start
Java Micro Edition
Sockets and Internet Protocols
Threads and Synchronization
Performance
Applets
I/O and Streams
Other Java APIs
Game Development
Java in General (beginner)
Java in General (intermediate)
Java in General (advanced)
Programmer Certification (SCJP)
Developer Certification (SCJD)
Associate Certification (SCJA)
Web Component Certification (SCWCD)
EJB Certification (SCBCD)
Mobile Application Certification (SCMAD)
Architect Certification (SCEA)
Web Services Certification (SCDJWS)
XML Certification
Product and Other Certifications
Mock Exam Errata
Sun Certification Results
Authors' Corral
Book Reviews
Events
Bunkhouse Porch
Teachers' Lounge
Testing
OO, Patterns, UML and Refactoring
IDEs, Version Control and other tools
Ant, Maven and Other Build Tools
Linux / UNIX
Mac OS
HTML and JavaScript
XML and Related Technologies
Agile and Other Processes
General Computing
Security
Groovy
Scala
Other Languages
Struts
Application Frameworks
Other Open Source Projects
BEA/Weblogic
IBM/Websphere
Oracle/OAS
Apache/Tomcat
JBoss
Other Java Products and Servers
JavaRanch
Cattle Drive (java college)
Moderators Only
Trash Can
Jobs Offered
Jobs Wanted
Jobs Discussion
Meaningless Drivel
Programming Diversions
Blatant Advertising
Java Announcements
New To Java
Advanced Java
Java Applets
Networking
Threads and Synchronization
Java 2D
AWT / Swing
SWT / JFace
CLDC and MIDP
CDC and Personal Profile
Sun Java Wireless Toolkit
Enterprise JavaBeans
JavaServer Pages (JSP) and JSTL
Java Servlet
JavaServer Faces
Web Frameworks
Database
XML
Lucene
NetBeans
Eclipse
IntelliJ IDEA
JCreator
Other IDEs
Java Tutorials
Java Tips
Jobs Discussion
Jobs Offered
Jobs Wanted
Professional Certification
Forum Lobby
Java Blogs
Introductions
Reviews / Advertising
Suggestions & Feedback

Resources

Java Database
Linux
Coding
Mobile
Hardware
Software Development
Software Development
iOS,OS X
iOS,OS X
ORACLE
IBM DEVELOPER
IBM DEVELOPER
MSDN
MSDN


Tags

Oracle

Oracle is probably the most popular enterprise database server at the moment. This is the server that powers eBay on the web and countless datawarehouses and VLDBs around the world. Oracle is suited for all applications from OLTP to Data Warehousing. The latest 9i even has a built in OLAP engine.

block based in procedure for Oracle Forms Developer


Hello,
In Oralce forms 6 I am trying to create a bock based in a procedure. I can insert data and update at b.d only but I can not select data so I can not delete. I have create all procedures like in www.osborne.com Examples from "Avanced Forms and Report" and I have used asistend to create block and Help of Forms 6. I am locking for code source is in trigger "when button pressed" to execute query of block. 
Thanks. Peternac26. Madrid (Spain).

Hola compaeros del metal,
En Oracle Forms 6 estoy intentando crear un bloque basado en un procedimiento. Puedo insertar y updatear en b.d pero no puedo ver los datos y por tanto borrar. He creado todos los procedimientos como el ejemplo de www.osborne.com "Examples de forms y reports avanzados" y he utilizado el asistente para crear el bloque y tambien he consultado la ayuda. Necesito el codigo que se podrĂ­a en el trigger when button pressed para ejecutar y ver los datos en el bloque.
Gracias. Peternac26. Madrid (Espaa).

alarcon_jp1@ya.com

bueno, la solucion es que no utilizar para el procedimiento de select
un ref cursor sino un tipo tabla igual que los demas procedimientos de
insercion, update, borrado y bloqueo. 
La estructura de datos que se utiliza:

 type RECORD_MANHOR_01 is RECORD 
  (
   TIPCOS  VECTRA_TRAHOR.TIPCOS%TYPE,
   TIPACC  VECTRA_TRAHOR.TIPACC%TYPE,
   FECVIG  VECTRA_TRAHOR.FECVIG%TYPE,
   CLAPAR  VECTRA_TRAHOR.CLAPAR%TYPE,
   DIASEM  VECTRA_TRAHOR.DIASEM%TYPE, 
   TIPHOR  VECTRA_TRAHOR.TIPHOR%TYPE, 
   HORINI  VECTRA_TRAHOR.HORINI%TYPE, 
   HORFIN  VECTRA_TRAHOR.HORFIN%TYPE
  );
 type T_MANHOR_01
     IS TABLE OF RECORD_MANHOR_01
     INDEX BY BINARY_INTEGER;

 

 procedure SELECT_MANHOR_01(p_cursor IN OUT T_MANHOR_01) IS
 
  cursor p_cursor2 is
  select   TIPCOS  ,
				   TIPACC  ,
				   FECVIG  ,
				   CLAPAR  ,
				   DIASEM  , 
				   TIPHOR  , 
				   HORINI  , 
				   HORFIN    
   FROM VECTRA_TRAHOR;
   contatore number default 1;
   
 BEGIN
   for cursor_rec in p_cursor2
      loop
    	     p_cursor(contatore).TIPCOS    := cursor_rec.TIPCOS;
    	     p_cursor(contatore).TIPACC    := cursor_rec.TIPACC;
    	     p_cursor(contatore).FECVIG    := cursor_rec.FECVIG;
    	     p_cursor(contatore).CLAPAR    := cursor_rec.CLAPAR;
    	     p_cursor(contatore).DIASEM    := cursor_rec.DIASEM;
    	     p_cursor(contatore).TIPHOR    := cursor_rec.TIPHOR;
    	     p_cursor(contatore).HORINI    := cursor_rec.HORINI;
    	     p_cursor(contatore).HORFIN    := cursor_rec.HORFIN;
    	     
    	     contatore:=contatore+1;
  	  end loop;
END;

El asistente crea un trigger INSERT-PROCEDURE que se ejecuta cuando hacemos un EXECUTE_QUERY.

buff, a costado !


Related Links

Analytical Functions Question
ORA-12514: TNS:listener could not resolve SERVICE_NAME.....
CBO confusing me
Call store procedure external
Querying Multiple Tables
drop connection
Create manually a database in Window (XP)
handle count leak when connecting to Oracle 9i via ODBC driver
subselect a cursor passed into PL/SQL
Steps to learn PL/SQL
LOV interaction
sqlplus /nolog problem
Plz solve this query ( 1 2)
Procedure Builder
Stored Procedure Error "PLS-00103: Encountered the symbol "SELECT" when expecting...&
intermedia text reading chars like '#'