Temp Tables called in Sybase by other Procedures
Posted on 2003-11-14
I am running Sybase 12.5
I essentially need the set up for how to call a nexted procedure (calling one procedure from inside another), and being able to reference the temp table that is generated in the parent.
Procedure #1 does calculations and stored data to 3 temp tables.
Procedure #1a - References a table generated in Procedure #1
Procedure #1b - References a table generated in Procedure #1
I don't have to return any values back from the sub procedures.
I'm looking for the syntax for calling a nested procedure in 12.5 and how to address the table that was generated in the parent procedure.
I have tried setting up the table as ##<global table>, but when I try to compile procedure 1a, it can not find the object and won't compile the procedure.