OraFAQ Forum: Forms » FRM-10769

Home » Developer & Programmer » Forms » FRM-10769 (Forms Builder 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-10769 [message #387229]

Wed, 18 February 2009 06:17

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 ...

Report message to a moderator

Re: FRM-10769 [message #387237 is a reply to message #387229]

Wed, 18 February 2009 07:04

Littlefoot
Messages: 21823
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
                           );

Report message to a moderator

Re: FRM-10769 [message #387553 is a reply to message #387237]

Thu, 19 February 2009 21:38

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

Report message to a moderator

Re: FRM-10769 [message #387570 is a reply to message #387553]

Thu, 19 February 2009 22:59

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Previous Topic:	FRM-40508
Next Topic:	excel to forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 21:07:32 CST 2025