This content has been marked as final. Show 2 replies
I succeeded with "::" instead of single colon.
But with OraOLEDB I am unable to pass line delimiter. For example:
begin null; -- xxx end;
and the compiler says end-of-file found.
Is there any lucky man who can execute anonymous blocks and create database objects such as triggers via OraOLEDB?
thanks for your suggestion. Unfortunately, using the double colon instead of the single column does not solve the problem. Have you tried this with wrapped code or did you use plain text code? And did you use MSDAORA or OraOLEDB?
Unfortunately, I am unable to help you with your problem concerning the OraOLEDB provider since we only use Microsoft's OLE DB provider for Oracle. Is there any reason why you chose to use OraOLEDB?