Subject | 'Procedure unknown' error on existing procedure |
---|---|
Author | Tiago Mikhael Pastorello Freire |
Post date | 2006-12-20T19:56:50Z |
The SQL is pretty simple: 'select * from GET_USER_CONTRACTS('user');'
I am getting a 'procedure unknown' error on my query in a php script, but when
I run the same query inside the database editor (EMS, IBExpert) it works.
Erro: -204 - Dynamic SQL Error SQL error code = -204 Procedure unknown
GET_USER_CONTRACTS At line 1, column 15.
I have even tried shutting down both apache and firebird and starting them
again, but the procedure is still only visible 'from the inside'.
What could be making this odd behaviour?
I am getting a 'procedure unknown' error on my query in a php script, but when
I run the same query inside the database editor (EMS, IBExpert) it works.
Erro: -204 - Dynamic SQL Error SQL error code = -204 Procedure unknown
GET_USER_CONTRACTS At line 1, column 15.
I have even tried shutting down both apache and firebird and starting them
again, but the procedure is still only visible 'from the inside'.
What could be making this odd behaviour?