Re: I can't create a PROCEDURE dynamically with Oracle DB
Originally posted by nmoreno
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?
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?
Cause: Special characters are valid only in certain places. If special characters other than $, _, and # are used in a name and the name is not enclosed in double quotation marks ("), this message will be issued. One exception to this rule is for database names; in this case, double quotes are stripped out and ignored.
Action: Remove the invalid character from the statement or enclose the object name in double quotation marks.
If you still can't see what the cause of this error is, post the SQL command string that you are trying to run.