Solved

Datablock and procedure in forms 6i

Posted on 2002-07-21
1
1,229 Views
Last Modified: 2007-12-19
hello,

i tried to insert data into datablock through the procedure in forms 6i.
i got error as
****************************
FRM-30433: Query procedure should have only one argument of type
REFCURSOR/TABLE and its mode should be IN OUT.
Block: BLK_DISPLAY
Procedure: GETDATA
FRM-30085: Unable to adjust form for output.
****************************
the steps i have done is
(i) i have written a procedure "GETDATA" in program unit
and is compiled without any error.
(ii) i went to the datablock property in which
     (a) Query data source type = Procedure
     (b) Query data source name = Getdata
     (c) Query data source column = i have given all the coloumns
            which have been selected using query (which i have
         written in the procedure GETDATA).
     (d) Query datasource arguments= i have given paramters which are
         in and out parameters of the procedure GETDATA. For example
         in the case of "IN" parameter
         i have given the parameter name in the 'Argument Names". in
         the value column i have given the text item name as
         :blk_display.txt_empno with corresponding type and mode.
         i have left blank for the Type Name.
what could be the error??
0
Comment
Question by:sukhoi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
M-Ali earned 50 total points
ID: 7168888
You also need to give one other argument:
Argument Name -> RESULTSET
Type -> REFCURSOR
Mode -> INOUT

I think you missed this.

HTH
Ali

0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sybase and replication server 13 83
Email query results in HTML 6 50
Select the 2 most recent visit dates 5 31
Performance Issue in Oracle 3 47
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question