Solved

Datablock and procedure in forms 6i

Posted on 2002-07-21
1
1,232 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

630 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