[DERBY-28] Execute Statement of a SYSIBM sps gives java linkage error and class not found exception.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Cannot Reproduce
• Affects Version/s: 10.0.2.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Ramandeep Kaur
• Created: 01/Oct/04 22:43
• Updated: 21/Jan/11 17:48
• Resolved: 30/Jul/07 20:59

Description

Opening this bug on behalf of Mamta Satoor.

------------------------------------------------------
Execute/Create/Drop statement is not supported anymore in
Derby but we do have internal sps in the database.
When I try to do say execute statement sysibm.getTableTypes;
I get 2 exceptions

Drop statement behaves more gracefully
ij> drop statement sysibm.getTableTypes;
ERROR 42X62: 'DROP STATEMENT' is not allowed in the 'SYSIBM'
schema.