This is my Java code:
Public class Data {
The Connection con=null;

Record Record=null;

Public ResultSet getTableInfo (String tableName, String wheStr, String orderField, String orderMethod, int page, int the items)
{
This. Record=new record ();
The ResultSet rs=null;
Try
{
DbConnection1 bConnection1=new DbConnection1 ();
Con=bConnection1. InitConn1 ();
The CallableStatement cs=getCon (.) prepareCall (" {call gzagritemp. Datamanage. GetTableInfo (? ,? ,? ,? ,? ,? ,? ,? ,?) } ");
Cs. SetString (1, tableName);
Cs. SetString (2, wheStr);
Cs. SetString (3, orderField);
Cs. SetString (4, orderMethod);
Cs. SetInt (5, page);
Cs. SetInt (6 items);
Cs. RegisterOutParameter (7, 4);
Cs. RegisterOutParameter (8, 4);
Cs. RegisterOutParameter (9, 10);
Cs. The execute ();
This. Record. SetAllItems (cs. Get int (7));
This. Record. SetPges (cs. Get int (8));
Rs=(ResultSet) cs. GetObject (9);
} the catch (Exception e) {
e.printStackTrace();
}
Return the rs;
}

Public Connection getCon ()
{
Return this. Con;

}
}

This is the exception information:
ORA - 06550: line 1, column 7:
PLS - 00201: must declare identifier 'GZAGRITEMP. DATAMANAGE'
ORA - 06550: line 1, column 7:
PL/SQL Statement ignored

This is a form of database storage process attributes:

CodePudding user response:

Gzagritemp. Datamanage. GetTableInfo

This is the name of your stored procedure?

The front is a user name, the middle one is the package name, last name is process?

CodePudding user response:

DATAMANAGE is a inclusions, you a JDBC connection user is GZAGRITEMP

CodePudding user response:

CodePudding user response:

Direct call? If may not be authorized, permission to execute the stored procedure

CodePudding user response:

reference 4 floor js14982 response:

direct call? If may not be authorized, execute a stored procedure access

how this authorization?

CodePudding user response:

Grant execute on GZAGRITEMP DATAMANAGE to GZNYZY

CodePudding user response:

refer to 6th floor sxq129601 response:

grant execute on GZAGRITEMP. DATAMANAGE to GZNYZY

I try 3 q

CodePudding user response:

refer to 7th floor Think_source response:

Quote: refer to the sixth floor sxq129601 response:

Grant execute on GZAGRITEMP. DATAMANAGE to GZNYZY

I try 3 q

authorization may need administrator account, not any accounts have access authorization

CodePudding user response:

Make sure the three object types and owner
To confirm whether there is a corresponding permissions

 select object_type, object_name, owner from dba_objects where the lower (object_name) in (' gzagritemp ', 'datamanage', 'gettableinfo');