Pl/sql

ROOT
1

Hello,
Is there any way to use PL/SQL from root?
eg. declaration statement?
DECLARE
l_client_id varchar2(30) := number;

…
etc?

Regards, Mariusz Sapinski

2

Hi, Mariusz

As far as I know, PL/SQL syntax is not supported in ROOT. The only possibility to work with SQL database is using TSQLServer class interface, where you should write your own SQL queries.

Regrads,
Sergey

3

Hi,

alternatively you could start a pSQL shell from inside Root (with ‘gSystem->Exec(…)’) and feed your commands there, maybe with a command file.

Oliver