Viewing LONG/Ref Cursor values

[bdias@akanda.com]

Hello Everyone

I was wondering if there is a way to view the values of a Long Variable or any variable defied as VARCHAR2(1000) or greater during debugging.

Also is there a way to view the value(s) of a REF CURSOR type.

i.e. OPEN AllRecs FOR select * from dual;

Can we view the contents of AllRecs if AllRecs is defiend as a REF CURSOR datatype ?

Many Thanks.

Bev

 

[Marco Kalter]

was wondering if there is a way to view the values of a Long Variable or any variable defied as VARCHAR2(1000) or greater during debugging.

The Oracle Debug API is limited to about 1000 characters. Longer values cannot be displayed.

Also is there a way to view the value(s) of a REF CURSOR type.

What do you mean by "the value(s)"?

------------------
Marco Kalter
Allround Automations

 

[bdias@akanda.com]

Thank you for the prompt reply.

Regarding my second question:
When a Ref Cursor type is "opened" and "filled" with values/rows can the values of those rows be seen in the debugger?

i.e OPEN AllRecs FOR Select Owner, Empno FROM EMP WHERE EmpNo = 15;

This SQL should "get" Owner and Empno "into" AllRecs (ref cursor datatype). So can I see the contents of AllRecs. I know that the Debuggers shows the RecordCount etc.. but is it possible to actually see the data as it is possible to see the data in a "collection" object ?

Thanks again

Originally posted by mkalter:

was wondering if there is a way to view the values of a Long Variable or any variable defied as VARCHAR2(1000) or greater during debugging.

The Oracle Debug API is limited to about 1000 characters. Longer values cannot be displayed.

Also is there a way to view the value(s) of a REF CURSOR type.

What do you mean by "the value(s)"?

 

[Marco Kalter]

The only way to view the cursor data it to fetch it into one or more variables. You cannot view an entire row or result set.

------------------
Marco Kalter
Allround Automations