TCommandType like for TOracleQuery

[khang]

Hi,
Is there a way to findout the SQL type (SQL, PLSQL nonSQL like CommandType in TOracleScript) for SQL from TOracleQuery

Thanks,

 

[Marco Kalter]

The TOracleQuery does not really know these concepts. It can only process SQL and PL/SQL. However, after execution you can check the FunctionType property to see what the exact command was.

 

[khang]

In fact, my exact problem is that I have an SQL String. And I 'd know before to execute it if it is an SQL or an PLSQL string. Because you can determine it in TOracleScript, I suppose, DOA has a ready-made function that parse the string and determine the type.

 

[Marco Kalter]

I suppose, DOA has a ready-made function that parse the string and determine the type.

Yes, but it's bound to the TOracleScript class.

A PL/SQL command starts with BEGIN, DECLARE, or CREATE [OR REPLACE] . A SQL string starts with one of the commands listed in the SQL Reference Guide. In all other cases it's a non-SQL command.

 

[khang]

thank you for your answer