SQL Developer


SQL Developer Test Case issue issues


I tried to create a test case with cursor as input parameter, It is throwing error. Also we are facing issues  with test case where we have overloaded procedure and multidimensional array, Can some one please help. here.
I tried to create a test case with cursor as input parameter, It is throwing error. Also we are facing issues  with test case where we have overloaded procedure and multidimensional array, Can some one please help. here.
No help is possible until you actually tell us what the error and issues are. SHOW US 1. WHAT you are doing2. HOW you are doing it3. WHAT results you are getting Also post any code needed to try to reproduce the problem
I created above test case on below a procedure , But in result it is showing error "Expected exception: [NONE], Received: [900: ORA-00900: invalid SQL statement ORA-06512: at line 4 ]" CREATE OR REPLACE procedure APPS.pr_emp_1(p_in IN SYS_REFCURSOR, p_count out number) as l_sal number:=0; l_total_sal number:=0;begin   loop   fetch p_in into l_sal;   l_total_sal := l_total_sal + l_sal;   exit when p_in%notfound; end loop; close p_in; p_count := l_total_sal; end;  

Related Links

backspace not working problem and a tip, Why?
BUG: 1.5.3 still can't use 64-bit JDK.
A problem about table?
Converted Reports
BUG: SQL Developer 1.5.3 CSV export column order broken
Accelerator to Toggle Case
Other Users filter loses the list
Upgrade problem. Connection lost.
Compile for Debug Results in "Error: No more data to read from socket"
Problems Generating Data Move Scripts in v1.5.1
Oracle SQL Developer 1.5.1
User define reports - Columns tab
Worksheet hang -> SQLDeveloper Hang.
Failed to disable constraints
Code Insight Problem ?
Constraint on Views

Categories

ORACLE DEV
Database Connectivity
Business Intelligence
BI Beans
Database Mobile Server...
Oracle Provider for OL...
Advanced Queueing
Customer Experience (CX)
Procurement
Java - JDBC Archive
Calendar
Oracle9i
PL/SQL XML Programming
Desktop Datacenter
Oracle Database Expres...
Integration - B2B
Enterprise Manager (Ko...
Developer Suite (Korean)
Applications (Korean)
Backup & Recovery (Kor...
Migration (Korean)
Industrial Manufacturing
Governance, Risk & Com...
Costing
Identity Management Ar...
SOA Suite and OC4J 11g...
Business Process Manag...
WebLogic Server - Clus...
bea.education.weblogic...
weblogic.developer.int...
weblogic.support.install
weblogic.developer.int...
weblogic.integration.d...
WebLogic Server - Mana...
Evolve
存档论坛
JDBC & Transaction (Ch...
BEA WebLogic RFID (Chi...
Forums Moderator Migra...
Java Message Service (...
CLDC and MIDP
JDK's Monitoring & Tro...
Java Runtime Environme...
Solaris Zones
JavaHelp System [ARCHIVE]
Java System Web Server
Accessibility
Java Plug-In
Java Upgrade
Java Errors and Error ...
Java Business Integrat...
Web Space Server
Kernel
Sun ONE Integration Se...
Sun ONE Integration Se...
Oracle Net (SQL*Net、Ne...
Database Migration Ass...
インストール
R Technologies
Primavera Unifier User...
Audit Vault and Databa...
HCM Functional Discuss...
Single Sign On
Israel Oracle User Gro...
VirtualBox
Big Data Discovery
Power Hour Hub
Data Quality and Clean...
SalesMastermind
Eloqua-Netsuite Integr...
Canadian B2B Marketers
SRM/Eloqua users
SQL
BICS Data Visualization
OMC - Industry Solutio...
...
Oracle Supply Chain Ma...
Modern Supply Chain Ex...
Java SE Early Access
Global Trade Management
Enterprise Quality Man...
Insurance Group
Oracle Academy - EMEA ...
Oracle Cloud Applicati...
RAC - Real Application...
Oracle Application Bui...
Duke's Choice Award 2016
Cúpula Virtual de Tecn...
Oracle Database Develo...
Application Server
Identity Manager
Application Server (Ko...
Data Quality
Automated Regression T...
Enterprise 2.0
weblogic.aqualogic.dat...
aqualogic.bpm.administ...
weblogic.eventserver.g...
产品专区
Solaris 10
OTN ArchBeat Podcast
Oracle HSM
Demand Management
Test Partner Industry ...

Resources

Encrypt Message