Posted: 12.05.2010, 19:12
akli_agha,
Well, the exact moment of the error isn't clear from your last message.
Is the problem
- you can't use the TZSQLProcessor component to create your stored proc?
- you can't execute the stored proc once it's created in the dabase?
In cas it's the first problem : there may be a problem because of the ':cr_date' being interpreted as parameters. Make sure the Paramcheck property of the TZSQLProcessor is False.
It may also be helpfull for us to see the output generated by a TZSQLMonitor to see what's exactly sent to the server as one command. So eventual bad splitups of the script may be reveiled.
Mark
Well, the exact moment of the error isn't clear from your last message.
Is the problem
- you can't use the TZSQLProcessor component to create your stored proc?
- you can't execute the stored proc once it's created in the dabase?
In cas it's the first problem : there may be a problem because of the ':cr_date' being interpreted as parameters. Make sure the Paramcheck property of the TZSQLProcessor is False.
It may also be helpfull for us to see the output generated by a TZSQLMonitor to see what's exactly sent to the server as one command. So eventual bad splitups of the script may be reveiled.
Mark