Re: PL/SQL Package Level Subtype Problem

I'm using Oracle 9i - sorry, should have stated that. Using subtype was a recommendation from a colleague - I'll try and find out why this was suggested (sorry, quite new to plsql myself). What would the equivalent TYPE syntax for this be? Can't seem to find a TYPE declaration which allows you to specify a table%rowtype...

REC_INFO.TEXT is a varchar2 - I've tried specifying pv_text as rec_info.text%type as you suggested, but unfortunately I get the same results.

Interestingly, if I do not supply a value in pr_info.text in the first procedure (so its NULL), the second procedure then allows me to set the value. Only when I set a value in the first instance does it not let me overwrite it. In fact, whatever I seem to do, as soon as a value is assigned I cannot overwrite it. Received on Wed May 17 2006 - 05:02:14 CDT