INTERBASE+PHP+STORED PROCEDURES

[Anon]

i created an stored procedure in interbase that returns 1 value (an unique id generated by a generator) how can i retrieve this value via PHP...in isql execute procedure procname ; works but i can't seem to find any docs on how to do this in PHP?

-chris

[Anon]

Chris,

Have you tried SELECT * FROM proc_name?

[Anon]

Hi! 🙂))

Use query like this:

SELECT * FROM STORED_PROCEDURE_NAME(PARAM1 [,PARAM2 ...])

for eg.

SELECT * FROM SELECT_DICTIONARY('states')

where SELECT_DICTIONARY is stored procedure and 'states' is a parameter.

Enjoy! 🙂))

Sir_Fred

[sankaty]

Ei Galera!!! Isso sozinho não funciona!!!!!!!!!!
SELECT * FROM PROCNAME();

Aqui o Código Certo...
O Erro está na Procedure:

parametro de saida: OS_NUM;
parametro local: numero_os;

SELECT GEN_ID(ORDEM_SERVICOS,1) FROM RDB$DATABASE INTO :numero_os;

for select os_num from oscad where os_num=:numero_os into 😮S_NUM
do begin
suspend;
end

execute assim:
SELECT * FROM PROCNAME();

Enviado por:

Brasil - Pernambuco - Recife - DataNorte Sistemas.