What do you mean by procedures?
You need to first use db_connect() witht he proper connection string
(Oracle, MSSql......) and only afterwards may you execute a query on the
open instance of dB.
User Eranga Nanayakkara (email@example.com) posted:
I assume you are talking about stored procedures.
I know for a fact that you cannot execute stored
procedures using Oracle as such commands as "set
serveroutput on " does not get executed.
What we did as a work around was we write the entire
stored procedure as SQL statements
from questions a, surveyquestions b " &
"where a.questionid = b.questionid and a.surveyid =" &
surveyID & "and b.versionid =" & versionID & "order by
db_execute query("conn", query,record_number");
# now the array will contain all the colum values in
# row (e.g. if i is 1 then the values of the first
# This is the only way we could figure out how
to retrieve data
# from the database and handle huge record
Note: I'm not sure whether itís possible to use stored
procedures in SQL server.