Home » Developer & Programmer » Forms » FRM-30433
FRM-30433 [message #239018] Mon, 21 May 2007 05:06 Go to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

I have a block based over on procedure(Query data source type=procedure), on query data source name I put PKG_x (this is my database package), then on Query data source arguments I put d_name, type is varchar2, type name is mvar, value is :global.name. When I press ctrl+T, I get this error:

FRM-30433: Query procedure should have only one argument of type REFCURSOR/TABLE and its mode should be IN OUT

Here's my Databse package:
CREATE OR REPLACE PACKAGE Pkg_Eval IS
TYPE clmusr IS RECORD (
unam VARCHAR2(50),
cuname VARCHAR2(50));
success CONSTANT NUMBER :=0;
TYPE clm_usr_ref IS REF CURSOR RETURN clmusr;
--TYPE clm_usr_tab IS TABLE OF clmusr INDEX BY BINARY_INTEGER;

PROCEDURE query_procedure (resultset IN OUT clm_usr_ref, d_name IN VARCHAR2);

END;


Package body:
CREATE OR REPLACE PACKAGE BODY Pkg_Eval IS

FUNCTION get_success RETURN NUMBER IS
BEGIN
RETURN(success);
END;

PROCEDURE query_procedure (resultset IN OUT clm_usr_ref, d_name IN OUT VARCHAR2) IS
BEGIN
OPEN resultset FOR
SELECT a.username, a.complete_name
FROM CLM_USR a
WHERE a.username = d_name;
END query_procedure;

END;
/


Re: FRM-30433 [message #239653 is a reply to message #239018] Wed, 23 May 2007 00:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'stored procedure' and then use the advanced search for ' 'stored procedure' ' <- use the quotes in your search.

Does this entry help? http://www.orafaq.com/forum/t/43562/2/

David
Re: FRM-30433 [message #239686 is a reply to message #239018] Wed, 23 May 2007 01:28 Go to previous message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

The nearest I have now is http://forums.oracle.com/forums/thread.jspa?messageID=601194&#601194
Previous Topic: ORA-01400: cannot insert NULL into
Next Topic: ABOUT ODBC FORMS 6I WITH MICRO SOFT SQL
Goto Forum:
  


Current Time: Thu Dec 08 02:15:25 CST 2016

Total time taken to generate the page: 0.14200 seconds