Menu

Sample Test not working

sandeep
2015-09-01
2015-09-24
  • sandeep

    sandeep - 2015-09-01

    Execute the following statement
    SQL> exec utplsql.test ('betwnstr',recomplie_in=>FALSE)

    Got the below error
    BEGIN utplsql.test ('betwnstr',recomplie_in=>FALSE); END;

      *
    

    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00306: wrong number or types of arguments in call to 'TEST'
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

    Can u please help me out on what i'm missing.

     
  • Paul Walker

    Paul Walker - 2015-09-06

    Hmm... I can't see anything obviously wrong with what you've posted here. Did the installation go OK? Are any of the objects invalid?

    Can you try the following:

    SELECT utPLSQL.version FROM dual;
    
     
  • Paul Walker

    Paul Walker - 2015-09-06

    Ignore my last post, I've just spotted the issue! Looks like you have a typo in the parameter name recompile_in.

    You've put:

    SQL> exec utplsql.test ('betwnstr',recomplie_in=>FALSE)
    

    Whereas it should be

    SQL> exec utplsql.test ('betwnstr',recompile_in=>FALSE)
    
     
    • sandeep

      sandeep - 2015-09-24

      Thank you , I figured it out.

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.