What is the SQL syntax for executing a stored procedure in Interbase?

I have several stored procedures, like:

GET_ALL_NAMES this has no input parameters, but returns two columns, several rows
GET_SELECTED_NAME this has one varchar input parametes, returns two columns, zero, one or several rows, depending on the input value
 
I have spent a few hours searching for this, in vain.
I use ASP.Net, and know how to do this using command objects and the like, that is not the problem.

What I want is a *PURE* SQL syntax for calling stored procedures and getting results returned.

--
Ingvarius  
IngvarNilsenAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Nick UpsonConnect With a Mentor Principal Operations EngineerCommented:
select return_param1, return_param2 from sp_name (passin_param1, passin_param2)

in your examples

select first_name, lastname from GET_ALL_NAMES ()

select col1, col2 from GET_SELECTED_NAME (invarchar)
0
 
IngvarNilsenAuthor Commented:
SUPER!!
The reason I gave this so many points is that I have hunted high and low for the answer, which for some reason is not easy to find, at least not for me.

BTW, the forst example,
  select first_name, lastname from GET_ALL_NAMES ()
does not work here, this works:
  select first_name, lastname from GET_ALL_NAMES
the parentheses gives an "unknown token" exception. Any comments?

FTR, I use the latest Firebird, and use the new generic DB components in ASP.Net 2.0

--
Invarius

0
 
Nick UpsonPrincipal Operations EngineerCommented:
Any comments? - my type

by latest firebird do you mean 1.5.3 or 2.0 rc3, the latter is only released for eval & testing
0
 
IngvarNilsenAuthor Commented:
I mean  1.5.3

--
Ingvarius
0
All Courses

From novice to tech pro — start learning today.