Results 1 to 3 of 3

Thread: proc

  1. #1
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    proc

    i am programming in proc.
    i have a local variable 'ls_date' inside a function. and using that inside a PL/SQL block in the same function.
    It's erroring as "Identifier must be declared".
    but the same program is working when i declare the variable 'ls_date' with global scope.
    what's the reson behind this?

    Last edited by Barbie; 05-14-2007 at 10:14 AM.

  2. #2
    Junior Member
    Join Date
    May 2007
    Answers
    11

    Re: proc

    You might be refering it some where else for sure.


  3. #3
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    Re: proc

    but that variable is not referred outside the function.
    We tried to figure out the reason. but we changed that variable as global and its running fine now.


  4.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact