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!

Passing ROWID as Procedure Parameter

149858Apr 19 2006 — edited Apr 19 2006

Hi,

I am calling a common procedure to insert some data, which requires the rowid as the parameter. Because there is no key on the table , I am using rowid to insert a particular row depending on rowid passed.
But my problem is how can i make a parameter variable equivilent to rowid of the table. I tried,

Procedure insert_proc ( p_rowid mtable.rowid%TYPE )

But this didn't work.

I can't create any key on table because table is coming from a flat file.

Can anybody help.
Thanks,
Vikas

Locked Post

New comments cannot be posted to this locked post.

Locked on May 17 2006

Added on Apr 19 2006

3 comments

2,005 views