Home » Developer & Programmer » Forms » Facing an error when adding stored procedure in Oracle Form(FRM-10764)
Facing an error when adding stored procedure in Oracle Form(FRM-10764) [message #82200] Tue, 06 May 2003 10:05
Ken
Messages: 50
Registered: April 1998
Member
I have a procedure unit in program unit , here is the codes:

PROCEDURE first IS
m_id varchar2(5);
BEGIN
select U_ID into m_id from MEMBERS;
END;

but when I am required to enter the procedure's name in the data block wizard (setting up stored procedure instead of table/view), it just turns out an error:

FRM-10764: No argument of type TABLE or REFCURSOR.

How to solve it?? Thanks so much

Report message to a moderator

Previous Topic: Menus
Next Topic: commit a log table without commiting other table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 15:41:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.