Home » Developer & Programmer » Forms » FRM-10769 (Forms Builder 9i)
FRM-10769 [message #387229] Wed, 18 February 2009 06:17 Go to next message
ksgsharma
Messages: 10
Registered: February 2009
Location: LR, Arkansas, US
Junior Member
When trying to give a SP name in the INSERT tab of Data Block Wizard and try to press NEXT button getting this error:

FRM-10769 : No argument of type TABLE

The SP SPEC is as follows:

TYPE emp_table_type IS TABLE OF EMPLOYEE.FNAME%TYPE;

PROCEDURE sp_insert_emp_det
(
as_emp_name IN emp_table_type,
as_emp_ssn IN EMPLOYEE.SSN%TYPE
);

Here EMPLOYEE is a DB Table and FNAME and SSN are its columns.

Both the SP SPEC and BODY are compiled successfully.

Please Help ...

Re: FRM-10769 [message #387237 is a reply to message #387229] Wed, 18 February 2009 07:04 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to set table type argument to IN OUT?
PROCEDURE sp_insert_emp_det(as_emp_name IN OUT emp_table_type,       --> this line
                            as_emp_ssn  IN EMPLOYEE.SSN%TYPE
                           );
Re: FRM-10769 [message #387553 is a reply to message #387237] Thu, 19 February 2009 21:38 Go to previous messageGo to next message
ksgsharma
Messages: 10
Registered: February 2009
Location: LR, Arkansas, US
Junior Member
Thanks mate .. but not working (Giving IN OUT for table type).
Still the same error is popping up (FRM-10769).

Sharma K
Re: FRM-10769 [message #387570 is a reply to message #387553] Thu, 19 February 2009 22:59 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I believe that you can do this in the database but not in the PL/SQL that runs in Forms.

David
Previous Topic: FRM-40508
Next Topic: excel to forms
Goto Forum:
  


Current Time: Wed Dec 07 18:14:41 CST 2016

Total time taken to generate the page: 0.09174 seconds