Subscribe Bookmark RSS Feed

Launch PL/SQL procedure into JMP

gbu

Community Trekker

Joined:

Jun 23, 2011

Hi all,

I would like to launch a PL/SQL (stored in Oracle database) procedure into JMP 7.02.

Through menu File -> Database -> OpenTable and in Advanced button, I select the procedure and give all parameters in the SQL window but when I clic on Execute SQL button, it fails.

Below the SQL construct automaticaly by JMP
EXECUTE CREATETABLE('MYTABLE')

Note : this PL/SQL procedure create a table named mytable.

Thanks for your help
Regards.