Executing stored procedure using db_execute_query
ex2=db_execute_query("query1","exec procname '','','MA','PPP','SUK','0','37.53133','-121.97344','75',',000A00070X','','rad'",rec_num1);
ex2 returns 0.
rec_num1 returns -1.
I have statements for connecting to and disconnecting from database.
If I replace the stored procedure with a simple select * from table statement, it works fine which means to say connection to the database is fine.
what is the error in the SQL statement I have.