Sybase SQL Anywhere 12.0.1.4134 This script to reproduce the problem:
) go
Now, perform basic query:
i get an error message: Could not execute statement. Illegal reference to correlation name 'TEST1' SQLCODE=-824, ODBC 3 State="42S02" though if the request to change bit
it is executed without error. That is the Problem that the SA12 is why it does not like the transfer of the table field as a parameter to the SP ( MyProc(TEST1.ID) ). Q: This is my fault, or this is a bug SA12 ? P.S. Sorry this error I can not check on the more recent versions (builds) SA12, so I do not have a subscription to technical support and version SA12 Developers stuck on 12.0.1.4134 ;-( asked 02 Jun '15, 11:11 Stalker |
AFAIK, you will need a LATERAL procedure call (or the OUTER/CROSS APPLY join operator) when you want to call a procedure with arguments taken from a table... I'd like to add a link to a great (as usual) Glenn Paulley article comparing LATERAL and the APPLY operators: answered 02 Jun '15, 11:24 Volker Barth |