Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
I create a stored procedure abc that creates a temporary table and then
returns the records. I then want to use those records in an sql statement but
filter them outside of the stored procedure:
select * from table (abc(para1,para2) as t1
where t1.some_field = 'XYZ'
As soon as I put any dml statements (such as create temp table / update /
insert) the sql does not run and tracing the stored procedure shows the error
675.
Are there any work arounds to this?
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.