Invalid Request BLR

[mdaems]

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