Hi!
I can't create a PROCEDURE dynamically with Oracle DB. I'm using ADO 2.7. But it works perfectly from SQL+.
What is wrong?

Thanks

I'm not sure I understand what you are tring to do here. Do you mean you want to do a CREATE PROCEDURE command via ADO? Not sure why you would be wanting to do that, but anyway... what error message do you get?

Yes, I want to execute a CREATE PROCEDURE via ADO / OLEDB.

The error message is: ORA-00911: invalid character.

Yes, I want to execute a CREATE PROCEDURE via ADO / OLEDB.

The error message is: ORA-00911: invalid character.

Here is the Oracle documentation for ORA-00911:

If you still can't see what the cause of this error is, post the SQL command string that you are trying to run.

This is the SQL Command:

CREATE OR REPLACE FUNCTION
nrmVersionNKB
RETURN INT IS
BEGIN
RETURN 200;
END;

Thanks.

This is the SQL Command:

CREATE OR REPLACE FUNCTION
nrmVersionNKB
RETURN INT IS
BEGIN
RETURN 200;
END;

Thanks.

Can't see any problem with that. Can you post the actual version that is in your code? I mean the one that looks more like:

strSQL = "CREATE OR REPLACE FUNCTION ...."

Maybe the problem lies there...

Thank you Tony.

I am working in oledb (ATL). I got "Invalid character" error because I didn't convert the string from ANSI to UNICODE. Now it works.

Thanks.

Thank you Tony.

I am working in oledb (ATL). I got "Invalid character" error because I didn't convert the string from ANSI to UNICODE. Now it works.

Thanks.