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

    a year later

    Chris,

    Have you tried SELECT * FROM proc_name?

      5 months later

      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

        a year later

        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.

          Write a Reply...