Recent content by rjv_rnjn

  1. R

    numeric or value error on converting clob to SMLType

    Thank you Bo, that was where I was wrong. I used Temporary Clob and saved the input in a file and it worked (putting the text where "(CLOB)" text comes up is also not the solution, it has to be saved -- just for the benefit of beginners), Thanks again.
  2. R

    numeric or value error on converting clob to SMLType

    Sorry for this confusion. I was trying the code in both PL/SQL developer and Oracle SQL developer to find out if there is a problem with my code block or some setting required in PL/SQL Developer. The code I run in PSD is declare begin open :csr for select tt.jno from ( select...
  3. R

    numeric or value error on converting clob to SMLType

    Hi, I'm trying to run the following code block declare testxml clob; begin textxml := '<root><no>1</no></root><root><no>2</no></root>' open :csr for select tt.no from ( select xmltype.extract (value(a), '/root/no/text()').getstringval() as no from table...
  4. R

    Output ref cursor in anonymous block

    Thank you Marco. The reference to chapter 4 was great; it got me going. BTW, how did you put the code tag? I didn't see any such icon on the editor window. Edit: Got it!
  5. R

    Output ref cursor in anonymous block

    Hi, I've just got started with Oracle & PL/SQL developer. To test my code I write anonymous blocks and execute them to test their correctness. I've been testing this on Oracle SQL developer and my code would run as expected. But when I take the same code in PL/SQL developer it throws errors. The...
See more
Back
Top