Author Topic: Error message PLS 00103  (Read 3324 times)

oracle_guy

  • Newbie
  • *
  • Posts: 11
    • View Profile
Error message PLS 00103
« on: April 16, 2009, 11:18:42 AM »
Hi I am trying to write a store procedure that contains 2 select statements and I want the union of that to be the output. My select statements work very well at the command line. But when I use it in a store procedure, I get errors such as the above or errors where the entire SQL statement is ignored after the SELECT statement. Can somebody point if there is a different way to code select statements in a SP.
Thanks


oratune

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Error message PLS 00103
« Reply #1 on: May 11, 2009, 01:12:12 PM »
Hi I am trying to write a store procedure that contains 2 select statements and I want the union of that to be the output. My select statements work very well at the command line. But when I use it in a store procedure, I get errors such as the above or errors where the entire SQL statement is ignored after the SELECT statement. Can somebody point if there is a different way to code select statements in a SP.
Thanks


Without seeing your code it's difficult to provide a solution.


David Fitzjarrell