Re: Cannot create a new table from PL/SQL

d.cook_at_niwa.cri.nz (Dave Cook) wrote:

Problem solved.

From Oracle support this morning I discovered the reason for my PL/SQL procedure not working - the username I was using must have the CREATE TABLE priv explicitly granted to it - as roles do not work from stored procedures.

Once granted, my procedure worked - too easy !

>As a new comer to PL/SQL programming I have having some problems
>creating a table from PL/SQL. I don't want to use PL/SQL tables, but
>want to create a completely new table which I can then query from
>outside PL/SQL (eg; from ARCINFO or Microsoft Excel).

GIS Administrator,                Email : d.cook_at_niwa.cri.nz
NIWA,                             Phone : (04) 386 0300