Home » SQL & PL/SQL » Client Tools » Sql Developer have problem ( Version 1.5.1)
Sql Developer have problem [message #335147] Mon, 21 July 2008 03:57 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi

I have created the procedure successfully (isql*plus)but when i trying to running the same in sql developer im getting compilation error what could be the problem


Create or Replace Procedure Vendor_detail is
Begin
Declare
    Cursor vendcur is Select vendcode,vendname from vendmast;
    Var_vendcur Vendcur%rowtype;
    MxGrndt Grinmain.Grindt%type;
    Grnno   Grinmain.Grinno%type;
Begin
   Open Vendcur;
   Loop
   Fetch Vendcur into var_vendcur;
   Exit when Vendcur%NotFound;
        Begin
           Select Max(grindt) Into MxGrndt
             From Grinmain
            where Vendcode = Var_vendcur.vendcode;
           Begin
                Select grinno Into Grnno
                  From Grinmain
                 Where Grindt = MxGrndt;
           Dbms_output.Put_line(' Vendname '||Var_vendcur.vendname||' Vendcode '||var_Vendcur.vendcode);
           Exception
                 When Too_many_rows Then
                      null;
                    --message('two many transaction on the date '||MxGrndt||' Vendcode '||var_vendcur.vendcode);
           End;                    
        Exception
            When No_Data_Found Then
                 null;
               --Message('No Grin''s prepared this vendor '||Var_vendcur.vendcode);
        End;
    End Loop;
    Close Vendcur;
End;
   
End;


screen shot of SQL Developer:

./fa/4670/0/


kanish
  • Attachment: pic1.JPG
    (Size: 150.98KB, Downloaded 341 times)
Re: Sql Developer have problem [message #335151 is a reply to message #335147] Mon, 21 July 2008 04:05 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Check this link
Previous Topic: How many lines of rows can be displayed through SQL PLUS
Next Topic: trimspool and linesize query
Goto Forum:
  


Current Time: Sun Dec 04 00:20:08 CST 2016

Total time taken to generate the page: 0.09665 seconds