Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Datablock and procedure in forms 6i

Posted on 2002-07-21
1
Medium Priority
?
1,234 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 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

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…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

670 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