Re: Various PL/SQL and Forms Queries...

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 20 Jun 1998 01:47:40 GMT
Message-ID: <358b13f1.4176104@192.86.155.100>

A copy of this was sent to Bernadette <b.pinto_at_zetnet.co.uk> (if that email address didn't require changing) On Fri, 19 Jun 1998 11:57:44 +0100, you wrote:

>Can someone answer the following questions for me please?:
>********
>Question 1
>********
>"PL/SQL variables reflect the Oracle 7 set of variables, but the
>datatype precisions aren't the same as those available in the database"
>
>Is the above true? If so, what is the maximum size of VARCHAR2, CHAR,
>LONG, RAW, LONG RAW in PL/SQL?
>

in plsql: in database:

varchar2 - 32k        2000 (o7)  4000 (o8)
char     - 32k        255  (o7)  2000 (o8)
long     - 32k        2 gig
raw      - 32k        255  (o7)  2000 (o8)
long raw - 32k        2 gig

>
>Thanks
>
>B. Pinto
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jun 19 1998 - 20:47:40 CDT