User Profile

Collapse

Profile Sidebar

Collapse
DARK SETH
DARK SETH
Last Activity: Jan 13 '12, 02:00 PM
Joined: Nov 25 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • DARK SETH
    replied to Function not returning values ( Sometimes??)
    in Oracle
    It must show both values. I tried creating the function with your code but got an error at the line

    FOR C_CONTACT1_NEW IN SELECT C_CONTACT1 into C_CONTACT1_NEW


    PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:

    ( - + case mod new null <an identifier>
    <a double-quoted delimited-identifier> <a bind variable>
    reverse avg c...
    See more | Go to post

      Leave a comment:

    • DARK SETH
      started a topic Function not returning values ( Sometimes??)
      in Oracle

      Function not returning values ( Sometimes??)

      Hi all

      My function return the a customer address. Some customers has got 2 then it doesn't return any values. The cust with one value does return the correct value. How can I fix this. Here is my Script

      Function

      Code:
      CREATE or replace FUNCTION get_add(acc_no IN varchar) 
   RETURN varchar 
   IS 
   	C_CONTACT1_NEW VARCHAR(50);
  
	  
BEGIN 
    
 
SELECT
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...