OraFAQ Forum: JDeveloper, Java & XML » whats wong with this??

Home » Developer & Programmer » JDeveloper, Java & XML » whats wong with this?? (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

whats wong with this?? [message #535368]

Tue, 13 December 2011 13:31

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

Report message to a moderator

Re: whats wong with this?? [message #535369 is a reply to message #535368]

Tue, 13 December 2011 13:40

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: whats wong with this?? [message #535370 is a reply to message #535368]

Tue, 13 December 2011 13:41

Barbara Boehmer
Messages: 9104
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.

Report message to a moderator

Re: whats wong with this?? [message #535371 is a reply to message #535368]

Tue, 13 December 2011 13:42

John Watson
Messages: 8964
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 17:35:58 CST 2025