TOracleScript and desc, exec

[nowy]

Hallo,
Does TOracleScript component support commands
desc and exec?
I could not make it working.
Desc gives me no output and exec doesn't inkove a stored procedure.

Using D6, DOA 3.4.6.4

Krzysztof

 

[Marco Kalter]

The DESC command will not work because it is a SQL*Plus command that is not yet supported by the TOracleScript. Instead of a DESC command you could query the dictionary views.

The EXEC command can be implemented by using a PL/SQL Block terminated with a / slash. Instead of writing this:

exec myproc('start');

You can do this:

begin
  myproc('start');
end;
/