Re: Some questions

From: <igal_at_healthstreet.com>
Date: Fri, 19 Jun 1998 14:41:25 GMT
Message-ID: <6mdtal$6fo$1_at_nnrp1.dejanews.com>


In article <1998061911581376740_at_zetnet.co.uk>,   Bernadette <b.pinto_at_zetnet.co.uk> 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?

CHAR,VARCHAR2,RAW - 32767 (only 255 , 2000 , 255 in Oracle) LONG,LONG RAW(not recommended) - 32760 (2 gigabytes in Oracle)

>
> ********
> Question 2
> ********
> I have tried to play around the the Forms 4.5 debugger but have had
> little success, can anyone tell me a simple way to set up and remove
> a break in a PL/SQL program unit local to the executing Form?

Personally, I never used the debugger. You can stop the execution by displaying an alert with the values of the variables you have to check.

>
> Thanks
>
> B. Pinto
>
>

Good luck,
Igal

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 19 1998 - 16:41:25 CEST

Original text of this message