Home » SQL & PL/SQL » SQL & PL/SQL » How to rewrite this stored procedure into a view ? (oracle 9i)
How to rewrite this stored procedure into a view ? [message #323341] Wed, 28 May 2008 04:35 Go to next message
saurav.raj
Messages: 8
Registered: May 2008
Location: BANGALORE
Junior Member

Hi all

I am trying to rewrite the attached stored procedure into a view.Can anyone help me to find out the exact solution?
Re: How to rewrite this stored procedure into a view ? [message #364766 is a reply to message #323341] Wed, 10 December 2008 00:23 Go to previous messageGo to next message
subhra_88
Messages: 14
Registered: April 2007
Location: Bangalore
Junior Member
writing a trigger would require you to get requirements like...when do you want to execute the code...after you get the requirements correct its easy to get this code in a trigger body and start debugging.
Re: How to rewrite this stored procedure into a view ? [message #364776 is a reply to message #364766] Wed, 10 December 2008 00:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why are you talking about trigger?

Regards
Michel
Re: How to rewrite this stored procedure into a view ? [message #364850 is a reply to message #323341] Wed, 10 December 2008 04:48 Go to previous message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
I think you're going to have to explain in a lot more detail what it is you want.
That procedure just returns a 1 or 0 depending on some data. What exactly do you think a view would accomplish here?
Previous Topic: "from-to" sequence from table data
Next Topic: Regarding the merge error
Goto Forum:
  


Current Time: Sat Dec 03 13:43:09 CST 2016

Total time taken to generate the page: 0.17350 seconds