Close command in OCI Oracle

[bart12872]

Hi,

I have a stage Oracle witch create a table in replace mode. I want to create 2 index on this table after it was created.

I succeed in create one index in Close command but no more.

Is it possible to do that.
Remark : I don't want to write the Create table SQL statement, just index statements.

thanks,
Martin.

[ray.wurlod]

Do you want to do this many times or just once?

If many times, why not assemble the CREATE INDEX statements into a stored procedure and execute that?

Otherwise, how have you attempted to execute multiple statements? Have you tried terminating the first one with a double semi-colon (";;")?