Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Location
    UK
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Writing Stored Procedures for Oracle

    Hi,

    I have previously wrote stored procedures for sql server, now I have to write them for oracle.

    I believe that they are different - and I am unable to find an example on the net.

    Has anyone got a simple example they could provide me?

    Thanks

  • #2
    Senior Coder A1ien51's Avatar
    Join Date
    Jun 2002
    Location
    Between DC and Baltimore In a Cave
    Posts
    2,717
    Thanks
    1
    Thanked 94 Times in 88 Posts
    hey are very different, I personnaly would try to find a book that specializes with Oracle and SQL. It is hard finding god SQL references online.

    I really do not know Oracle, but this is a snip of code from a book I use that showed the difference between Oracle and SQL.

    Code:
    CREATE PROCEEDURE MailingListCount
    (ListCount OUT Number)
    IS
    BEGIN
         SELECT * FROM Users
         WHERE NOT user_email IS NULL
          ListCount := SQL%ROWCOUNT;
    END;
    Eric
    Tech Author [Ajax In Action, JavaScript: Visual Blueprint]


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •