Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Datablock and procedure in forms 6i

Posted on 2002-07-21
1
Medium Priority
?
1,244 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
1 Comment
 
LVL 6

Accepted Solution

by:
M-Ali earned 150 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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 shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Suggested Courses

926 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