Home » Developer & Programmer » JDeveloper, Java & XML » whats wong with this?? (oracle 10g)
icon4.gif  whats wong with this?? [message #535368] Tue, 13 December 2011 13:31 Go to next message
nitish023
Messages: 1
Registered: December 2011
Location: India
Junior Member

create or replace procedure TEqqSTINSERT1(szApplData varchar2) as language java
name 'Input.putsData(java.lang.String)';
Sad
Compilation unit analysis terminated
Re: whats wong with this?? [message #535369 is a reply to message #535368] Tue, 13 December 2011 13:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: whats wong with this?? [message #535370 is a reply to message #535368] Tue, 13 December 2011 13:41 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
It works for me. Can you post a copy and paste of your run of the code from SQL*Plus, not some tool, making sure that you include the / on the line below, then "show errors" on the line below that, as I did below.

SCOTT@orcl_11gR2> create or replace procedure TEqqSTINSERT1(szApplData varchar2) as language java
  2  name 'Input.putsData(java.lang.String)';
  3  /

Procedure created.

SCOTT@orcl_11gR2> show errors
No errors.

Re: whats wong with this?? [message #535371 is a reply to message #535368] Tue, 13 December 2011 13:42 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum, Nitesh.
You need to give a lot more information before anyone can help. Look at this:
orcl> create or replace procedure TEqqSTINSERT1(szApplData varchar2) as language java
  2  name 'Input.putsData(java.lang.String)';
  3  /

Procedure created.

orcl>

You code (such as it is) works for me. You need to post the entire session, so that everyone can see what you are doing and what the error is. And you MUST post it as I did, properly formatted.

Previous Topic: Selecting the attribute value of given xmltype
Next Topic: how to load file 'oracle weblogic server'
Goto Forum:
  


Current Time: Thu Mar 28 13:00:53 CDT 2024