Stored procedure

Applications Forms
#1

Hi to all,
I’ve a problem trying to call a store procedure pushing a php button.
This store procedure write a file using a SELECT INTO OUTFILE mysql statement.
If I try to execute the store procedure with mysql command line or mysql browser the store procedure work fine.
If I try to execute it with SC_EXEC_SQL(“CALL ProcedureName({arg1},{arg2})”); an error occur:

ERROR

Undefined property: generazione_cards_ini::$nm_bases_mssql
in_array() [function.in-array]: Wrong datatype for second argument
Errore durante l?accesso alla banca dati:
PROCEDURE db_fidelity.CreaFileAF_PDV can’t return a result set in the given context
call CreaFileAF_PDV(3000,1)

Executing StoredProcedure that does not involve SELECT INTO OUTFILE does not produce error.
Can enyone help me please?

Best regards
Marcov

#2

Stored procedure

Thank you for directing me to the SQL example as it is an SQL stored procedure. I have used the QCMDEXC before but not within the scope of an SQL procedure. Thanks again for the assist.
By the way, I’m a happy owner of

SPAM WONT BE TOLERATED.

:->