identifier must be declared error when executing stored procedure in VB6

Question

ssqlstmt = "{Call STORED_PROCEDURE(" & INPUTPARAM & ")}"
iResult = objConnect.ExecuteSP(ssqlstmt, 1)
If iResult <> 0 Then    
        MsgBox "Error"
Else
        MsgBox "Success"
End If

Error Message:

[Microsoft][ODBC driver for Oracle][Oracle]ORA-06550: line 1, column 7: PLS-00201: identifier 'STORED_PROCEDURE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

What type of object is objConnect? Would be helpful to show more of the code for context. Is your SP literally called "STORED_PROCEDURE" or is that a placeholder/redaction ? — Tim Williams
Please edit the question with a minimal reproducible example including: the DDL (CREATE PROCEDURE) statements for creating the procedure; what the INPUTPARAM value is. — MT0
See for a good example: stackoverflow.com/questions/4558714/… — Tim Williams

ekochergin ekochergin · Accepted Answer · 2021-03-11T21:34:36

Such an error means either user has no access to that stored_procedure or the stored_procedure doesn't exist in the db.

Check the spelling. It would be really annoying to go through the next steps just because of some typo. And don't forget to check if the stored_procedure resides within a package. In this case you should call is using package's name:
```
call STORED_PACKAGE.STORED_PROCEDURE
```
Login via sqlplus using credentials your program logs in with and try to call stored_procedure from there. I believe you'll face the same error message
Login as some more "powerful" (as a developer account or even as sys) user in order to see whether the procedure exists in the database and whether the user your VB-program uses has enough privileges to run the routine.

identifier must be declared error when executing stored procedure in VB6

1 Answers