I'm running SQL Anywhere 9.0.2.3249. When saving a stored procedure or function to the database, SQL Anywhere applies it's own formatting to the code before storing it. The issue I …

I have declared a procedure which creates a temporary table like: create table #parents( id integer null, ) now there is something like an insert into #parents using the …

How would you retrieve formatted stored procedure source from the SQL Anywhere system tables. I use the following: SELECT IsNull(source, proc_defn) as 'text' FROM SYSPROCEDURE wh …

-- Not sure if this a bug, or a lack of understanding on my part... but I want to use a DEFAULT value of NULL on a stored procedure parm, and SQLA returns a value of 0 when I would …

What SQL do I use to get a list of functions and a list of procedures from the database? I need to get two distinct lists. This SQL brings back both procedures and functions in one …

I've got a complicated calculation that involves several lines of my stored procedure. This is in several places throughout the stored procedure. So I'd like to encapsulate it, u …

Per Breck's suggestions, I am adding another question directly about how SQLA passes parameters. In the past couple years the question has come up several times when trying to mov …

I'd like to see records added to the stored procedure language of SQA. One of the biggest complaints from my developers when moving code from Oracle to SQLA is the lack of records …

Another Oracle feature that I would like see added to is some sort of collections in the procedure language. The ability to have arrays at a minimum would be very beneficial. Ora …