Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Getting error - cannot find symbol for import and @

ora_1978Mar 19 2014 — edited Mar 21 2014

I am getting error like cannot find symbol for import and @ . How to resolve it ?

  1  create or replace and compile java source named "AddressTypeDbProcedure" as
  2  import javax.xml.bind.annotation.XmlAccessType;
  3  import javax.xml.bind.annotation.XmlAccessorType;
  4  import javax.xml.bind.annotation.XmlElement;
  5  import javax.xml.bind.annotation.XmlSeeAlso;
  6  import javax.xml.bind.annotation.XmlType;
  7  public class AddressType {
  8      @XmlElement(name = "StreetAddress")
  9      protected String streetAddress;
10      public String getStreetAddress() {
11          return streetAddress;
12      }
13      public void setStreetAddress(String value) {
14          this.streetAddress = value;
15      }
16* };
17  /

Warning: Java created with compilation errors.

SQL> show errors;
Errors for JAVA SOURCE "AddressTypeDbProcedure":

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      AddressTypeDbProcedure:1: cannot find symbol
0/0      6 errors
0/0      location: package javax.xml.bind.annotation
0/0      import javax.xml.bind.annotation.XmlAccessType;
0/0      ^
0/0      AddressTypeDbProcedure:2: cannot find symbol
0/0      symbol  : class XmlAccessorType
0/0      location: package javax.xml.bind.annotation
0/0      import javax.xml.bind.annotation.XmlAccessorType;
0/0      ^
0/0      AddressTypeDbProcedure:3: cannot find symbol

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      symbol  : class XmlElement
0/0      location: package javax.xml.bind.annotation
0/0      import javax.xml.bind.annotation.XmlElement;
0/0      ^
0/0      AddressTypeDbProcedure:4: cannot find symbol
0/0      symbol  : class XmlSeeAlso
0/0      location: package javax.xml.bind.annotation
0/0      import javax.xml.bind.annotation.XmlSeeAlso;
0/0      ^
0/0      AddressTypeDbProcedure:5: cannot find symbol
0/0      symbol  : class XmlType

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      location: package javax.xml.bind.annotation
0/0      import javax.xml.bind.annotation.XmlType;
0/0      ^
0/0      AddressTypeDbProcedure:7: cannot find symbol
0/0      symbol  : class XmlElement
0/0      location: class AddressType
0/0      @XmlElement(name = "StreetAddress")
0/0      ^
0/0      symbol  : class XmlAccessType
SQL>

Vinodh

Comments

624104
You have got to be kidding me, he's kidding right? Come on man... sample data or something I mean jeez all day with this


Ok maybe a bit harsh... but we really need to see some sample data and desired output to help you faster to get your file to your boss...

TimS

Edited by: TimS on Apr 15, 2009 3:36 PM
APC
Bear in mind that the COLUMN commands only apply to columns in the SELECT statement which match, Because you're applying format masks to the columns they have new column names and so don't match. This means you'll need to add aliases to everything in your query...
select
    RPAD(NVL(RZFIDOC_SCHOOL_YEAR,' '),1) as school_year,
    ....
Alternatively, extend those COLUMN columns to include JUSTIFY LEFT, JUSTIFY CENTER or JUSTIFY RIGHT instead of padding.

Cheers, APC

blog: http://radiofreetooting.blogspot.com
6363
Please help my boss is waiting for the file
Seems to be a lot of urgent help needed for output from tables based on student, assignment, exam scores and lecturer data right now.

Are you sure you mean boss and not teacher?
651180
You don't have to make fun of me sr, maybe you are a genious
I am trying to create a file like this one, but I need to put the file in the right positions
like 0 start in position one and end in pos1...
if you see the preivious email you will know what I mean...
Please don't answer, but just don't make fun..ok

0Kinder John 2231 Delamere Drive Cleveland OH44106 112419863028497742 3 3526 jkinder@connelite.edu 00256696 \
APC
I don't know why you replied to my post as I'm the only person who has offered you helpful advice.

Regards, APC

blog: http://radiofreetooting.blogspot.com
624104
Heh poor APC caught in the crossfire... maybe it was to me, sorry if you took offense. I see a LOT of people come in here just throwing queries out and expecting us to know what the heck they want from it.

Either way read APC's example that is the most obvious problem, try that and show us your output and we'll go from there.

TimS
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 18 2014
Added on Mar 19 2014
4 comments
3,088 views