Oracle call failed; sqlcode = -900; message: ORA-00900: inva

[kriskkumar]

Tried to use all of the following stmts in the OPEN command of oracle enterprise stage (DS 7.5.1) and get the above error, did anyone get a resolution on this ?

'DELETE FROM TABLE1'
'DELETE FROM TABLE1;'
"DELETE FROM TABLE1"
"DELETE FROM TABLE1;"
DELETE FROM TABLE1

I am using the Load and append options. There was just one other post on this and no resolution mentioned.




Thank you,

[Abburi]

Tried to use all of the following stmts in the OPEN command of oracle enterprise stage (DS 7.5.1) and get the above error, did anyone get a resolution on this ?

'DELETE FROM TABLE1'
'DELETE FROM TABLE1;'
"DELETE FROM TABLE1"
"DELETE FROM TABLE1;"
DELETE FROM TABLE1

I am using the Load and append options. There was just one other post on this and no resolution mentioned.




Thank you,

The statement that you've tried to execute is not a valid SQL statement.

[kriskkumar]

What is invalid about the stmt, can you elaborate or post a valid stmt for delete.

Thanks,

[csrazdan]

Tried to use all of the following stmts in the OPEN command of oracle enterprise stage (DS 7.5.1) and get the above error, did anyone get a resolution on this ?

'DELETE FROM TABLE1'
'DELETE FROM TABLE1;'
"DELETE FROM TABLE1"
"DELETE FROM TABLE1;"
DELETE FROM TABLE1

I am using the Load and append options. There was just one other post on this and no resolution mentioned.

Thank you,

From Oracle documentation:

Code: Select all

ORA-00900 invalid SQL statement

Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed.

Action: Correct the syntax or install the Procedural Option.

Login to Oracle using SQL Plus check the banner. Also check if you are able to create procedures.

Hope it helps......

[kriskkumar]

The delete stmt works fine in toad and also I have created a DataStage job just to delete the rows and it works fine, looks like it doesnt work in OPEN command!

[csrazdan]

The delete stmt works fine in toad and also I have created a DataStage job just to delete the rows and it works fine, looks like it doesnt work in OPEN command!

I'm not questioning your delete statement. What I want to know is if you can create procedures on this database?

I'm not sure but it looks like DataStage creates a procedure for Open statement for execution.

Following code will sumilate the situation:

Code: Select all

CREATE OR REPLACE PROCEDURE TEST_ME
IS
BEGIN
   DELETE FROM TABLE_NAME;    
END TEST_ME;

Create this procedure in TOAD/SQL Prompt and exeute it. If you are not able to create this procedure, you may have to talk to your DBA.

Hope it helps......