![]() Of course it could be an accidental and unwanted conversion because the projection of the SELECT statement doesn't match the signature of the REF CURSOR record. ![]() From the list, select the database where you want to connect it. After launching SQL Developer, it will now know where to get the list of TNS entries for db connection. In that case you may need to make it explicit, with the appropriate format mask. Tools menu -> Preferences -> Database -> Advanced -> TNSNAMES Directory -> Click the browser and select the path somethink like this: C:\xyz\product\11.2.0\client1 etwork\admin. Alternatively you may have an implicit cast. This may be signalled by an explicit TO_NUMBER() or TO_DATE, in which case you need to check the format mask and/or the data content. What you need to look for is a string being cast to a number or date variable, or a number being cast to a date field. Fortunately the Code Editor in SQL Developer will put line numbers in the gutter if you are not seeing line numbers you will need to toggle a preference. Without seeing your whole procedure it is not possible for us to pinpoint line 16. This error points to a flawed data type conversion which occurs at line 16 of your procedure. Whatever it may appear like sometimes, PL/SQL errors are not randomly generated. In your comment you sayHere is the error: ORA-06502: PL/SQL: numeric or value error Instance.LSWKT_CHGOFF_RECOV.SP ( P_AS_OF_DT, REF_CUR ) ĭBMS_OUTPUT.Put_Line(' SOURCE_CD AS_OF_DT CHRG_OFF_RECOV PROCESS_DT EFFECT_DT ACCOUNT_NBR NAICS_CD PROD_TYPE OFF_NBR BORROWER_NM TRAN_TYPE_CD TRAN_TYPE_DESC TRAN_AMT NOTE_DT ACCRU_CD NON_ACCR_CD COMM_SB_IND') REF_CUR instance.LSWKT_CHGOFF_RECOV.CUR_TYPE Here is the code I used to call my package (generated by TOAD): DECLARE or above or JDK 1.6.003 or above for SQL Developer versions up to 1.5.5. I guess the question is this possible and if so, what do I need to do. Contribute to lazarusllong/sqldeveloper-package development by creating an. You can open and edit these files from within SQL Developer. Supporting the version control is a File Browser to browse and read files stored in the file system. Type cur_type is ref cursor return rec_type Oracle SQL Developer 1.5 (April 2008) Oracle SQL Developer 1.5 is the 'Version Control' release, as it includes integration with open source version control products, CVS and Subversion. ![]() Process_dt lswk_%TYPE,Įffect_dt lswk_%TYPE,Īccount_nbr lswk_%TYPE,īorrower_nm lswk_%TYPE, Source_cd lswk_source_cd%TYPE,Īs_of_dt lswk_as_of_dt%TYPE, Below is the package definition: CREATE OR REPLACE package instance.lswkt_chgoff_recov I am using Oracle SQL Developer, but I am having an issue seeing results from a package that returns a ref cursor. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |