PL/SQL (MOSC)

MOSC Banner

need to fix an error in the above code

edited May 14, 2012 1:35AM in PL/SQL (MOSC) 3 commentsAnswered
hi,please help me to resolve this error
CREATE OR REPLACE PROCEDURE XXLOT_TRANSLATE(P_LPN_NUMBER IN VARCHAR2,P_POSTFIX IN VARCHAR2) IS
          l_transaction_type_id                             NUMBER ;
          l_transaction_action_id                           NUMBER;
          l_transaction_source_type_id                  NUMBER ;
          l_orgANIZATION_id                                NUMBER ;
          l_txn_header_id                                    NUMBER;
          l_txn_if_id1                                           NUMBER;
          l_txn_if_id2                                          NUMBER;
          l_txn_if_id3                                          NUMBER;
         l_parent_id                                           NUMBER;
         l_sysdate                                                 DATE;
         l_item_id                                            NUMBER ;
         l_user_id                                            NUMBER;
         l_quantity                                           NUMBER;
         l_lpn_id                                             NUMBER;
         l_locater_id                                       NUMBER;
         l_lot_number                                     VARCHAR2(20);
         l_distribution_account_id                     NUMBER;
         l_subinv_code                                    VARCHAR2(10BYTE);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center