all_tab_columns in a stored procedure?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 30 Jul 2002 08:48:56 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7026F7C10@lnewton.leeds.lfs.co.uk>

If you want an SP and SQLPLus to perform identically, type this into SQLPlus before doing anything ...

SET ROLE NONE; Then try your selects etc. The above command turns off any privs you have been allocated through roles and this is the environment that you will be running when running the SP.

Remember that SQLPlus is a totally different environment from PL/SQL so expecting them to be the same is a bit optimistic - like expecting C and C++ to give the same results for the same function - when they don't necessarily do so. (Major PITA).

Enjoy.

Regards,
Norman.

-----Original Message-----
From: rajXesh_at_hotmail.com (RK) [mailto:rajXesh_at_hotmail.com] Posted At: Monday, July 29, 2002 1:48 PM Posted To: server
Conversation: all_tab_columns in a stored procedure? Subject: Re: all_tab_columns in a stored procedure?

>> I expect a query on ALL_TAB_COLUMNS, either to behave like it does in
>> SQL*PLus or Not to give any results.
Received on Tue Jul 30 2002 - 02:48:56 CDT