SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to pass table type variable to a stored procedure

379897Feb 4 2003 — edited Feb 13 2003

Hi,

I am passing a table type variable to a stored procedured from a PL/SQL program.

I am getting the following error.

ORA-06550: line 39, column 9:
PLS-00306: wrong number or types of arguments in call to 'MAIN'
ORA-06550: line 39, column 9:
PL/SQL: Statement ignored

Anyone please suggest how this has to be done.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 13 2003

Added on Feb 4 2003

5 comments

1,518 views