Mohamed,
I knew if I answered a pl/sql question someone would
jump to the conclusion that I actually know something
about pl/sql ;)
I'm sure Jared or one of the other pl/sql experts can
give you an example or explain this better, but I'll
just have to give you the gist of the idea and hope
that someone will correct me if I'm wrong.
The problem is probably because you're trying to do a
simple select to populate the xx variable. I think
you need to open a cursor to get the info from the
table and then use the cursor to populate the xx
variable.
HTH,
- Anita
- Mohamed Gad <mgad_at_itsoft.com.eg> wrote:
>
> Anita,
>
> Thanks a lot for your help,
> I just find that the variable contains null as you
> said the cause of this
> when I try to select column of type long raw (its
> length is greater than
> 32760) into variable of type long raw using pl/sql
> the value of the variable
> is null so how can I solve this.
>
> Best Regards
> Mohamed Gad
> ITSoft, The software Factory of International
> Turnkey Systems (ITS)
>
> 16 Lebanon st., Mohandeseen, Giza, Egypt
> Tel: +20-2-3048561/2/3
> Fax: +20-2-3048564
> email: mgad_at_itsoft.com.eg
> URL: www.itsoft.com.eg
>
> --
> Author: Mohamed Gad
> INET: mgad_at_itsoft.com.eg
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
Received on Mon Jun 26 2000 - 08:02:55 CDT
