473,386 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > oracle database > questions > procedure return two values

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Procedure Return two values

75
I have Created one oracle store procedure .There are total 3 parameters 2 in and 1 out parameter ,

I need to insert the out parameter into the table . Put when I am firing insert statemet that will insert only one value .

Could you tell me how to insert more than one values if your procedure returning two values .

My code was little lengthy so could not able to paste here .

I am giving you emp talble exam ..suppose following procedure returning two values

Expand|Select|Wrap|Line Numbers
  1.  
  2. Create or replace procedure empty (v_ename varchar2,v_empno varchar2,v_childname out varchar2) as
  3. TYPE childname IS REF CURSOR;
  4. v_childname childname;
  5. begin
  6. open childname for select childname from emp where ename=v_ename and empno= v_empno 
  7. FETCH v_childname INTO v_childname ;
  8. EXIT WHEN v_childname %NOTFOUND; 
  9. end loop;
  10. end ;
  11.  
if this procedure retruns two value then how to handle these two values ... Please reply

Thanks
Mar 18 '08 #1
18 2313
amitpatel66
2,367 Expert 2GB
Could you please post your insert statement here.
Mar 18 '08 #2
amitpatel66
2,367 Expert 2GB
Orajit,


Please make use of [code] TAGS when ever you post any source code in this forum. Using CODE TAGS increases the readability and clarity of the source code. For more on posting guidelines, please check http://www.thescripts.com/forum/faq.php?faq=posting_guidelines

MODERATOR
Mar 18 '08 #3
orajit
75
Expand|Select|Wrap|Line Numbers
  1.  
  2. Declare 
  3. v_sonname varchar2(100);
  4. begin 
  5. empty ('Dev',101,v_sonname);
  6. insert into Emp_family_info('001',v_sonname,999);
  7. end ;
  8. /
  9.  
This will insert only one value in Emp_family_info table.

could please guide me if i insert more than one value then i could i do this .

Thanks

Orajit: Please note that the CODE TAGS should end with [/code]
Mar 19 '08 #4
debasisdas
8,127 Expert 4TB
What do you mean by two values ?

Two out parameters or two rows ?
Mar 19 '08 #5
orajit
75
two values...one output parameter returns two values ..


how to do that ..hope u clear my query ..Thanks
Mar 19 '08 #6
amitpatel66
2,367 Expert 2GB
Check this out:

Expand|Select|Wrap|Line Numbers
  1.  
  2. SQL> SELECT * FROM EMP;
  3.  
  4. ENAME                     EMPNO DAT
  5. -------------------- ---------- ---------
  6. a                             2 17-MAR-08
  7. a                             1 17-MAR-08
  8.  
  9. SQL> ed
  10. Wrote file afiedt.buf
  11.  
  12.   1  CREATE OR REPLACE PACKAGE pkg AS
  13.   2  TYPE emp_name IS TABLE OF emp.ename%TYPE;
  14.   3* END pkg;
  15. SQL> /
  16.  
  17. Package created.
  18.  
  19. SQL> ed
  20. Wrote file afiedt.buf
  21.  
  22.   1  CREATE OR REPLACE PROCEDURE get_data(emp_no IN NUMBER, e_name OUT pkg.emp_name) AS
  23.   2  BEGIN
  24.   3  SELECT ename BULK COLLECT INTO e_name FROM emp WHERE empno = emp_no;
  25.   4* END get_data;
  26. SQL> /
  27.  
  28. Procedure created.
  29.  
  30. SQL> SET SERVEROUTPUT ON
  31.  
  32. SQL>  DECLARE
  33.   2   enam pkg.emp_name;
  34.   3   BEGIN
  35.   4   get_data(1,enam);
  36.   5   FOR I IN enam.FIRST..enam.LAST LOOP
  37.   6   INSERT INTO EMP VALUES(enam(i),1,sysdate);
  38.   7   COMMIT;
  39.   8   DBMS_OUTPUT.PUT_LINE(enam(i));
  40.   9   END LOOP;
  41.  10   end;
  42.  11  /
  43.  
  44. a
  45.  
  46. PL/SQL procedure successfully completed.
  47.  
  48. SQL> select * from emp;
  49.  
  50. ENAME                     EMPNO DAT
  51. -------------------- ---------- ---------
  52. a                             2 17-MAR-08
  53. a                             1 17-MAR-08
  54. a                             1 19-MAR-08
  55.  
  56. SQL> DECLARE
  57.   2  enam pkg.emp_name;
  58.   3  BEGIN
  59.   4  get_data(1,enam);
  60.   5  FOR I IN enam.FIRST..enam.LAST LOOP
  61.   6  INSERT INTO EMP VALUES(enam(i),1,sysdate);
  62.   7  COMMIT;
  63.   8  DBMS_OUTPUT.PUT_LINE(enam(i));
  64.   9  END LOOP;
  65.  10  end;
  66.  11  /
  67.  
  68. a
  69. a
  70.  
  71. PL/SQL procedure successfully completed.
  72.  
  73. SQL> select * from emp;
  74.  
  75. ENAME                     EMPNO DAT
  76. -------------------- ---------- ---------
  77. a                             2 17-MAR-08
  78. a                             1 17-MAR-08
  79. a                             1 19-MAR-08
  80. a                             1 19-MAR-08
  81. a                             1 19-MAR-08
  82.  
  83. SQL> 
  84.  
  85.  
Hope this is helpful
Mar 19 '08 #7
orajit
75
Expand|Select|Wrap|Line Numbers
  1. Declare 
  2.    v_sonname pkg.emp_name;
  3. begin 
  4.    empty ('Dev',101,v_sonname);
  5.    FOR I IN v_sonname.FIRST..v_sonname.LAST 
  6.    LOOP
  7.      insert into Emp_family_info('001',v_sonname,999);
  8.   end loop;
  9. end ;
  10. /
  11.  

Please find my above calling code .. Its working fine for values more than 1 ..
But now i am sending another input parameter that will give me one value...but this code gives me duplicate values ...how to avoid this ..

Input parameter -----output values
dev ,101 sen,sun
leo,102 kun
jeo,103 set,mat,jen

etc

how to achieve this ... hope u got my question ...

need ur help ffor above ,,thanks ....
Mar 19 '08 #8
amitpatel66
2,367 Expert 2GB
I do not understand your question. In your code, there needs to be a small change. In the insert statement, for second value, it should be v_sonname(i)
Mar 19 '08 #9
orajit
75
Expand|Select|Wrap|Line Numbers
  1. Declare 
  2. v_sonname pkg.emp_name;
  3. begin 
  4. empty ('Dev',101,v_sonname);
  5. FOR I IN v_sonname.FIRST..v_sonname.LAST 
  6. LOOP
  7. insert into Emp_family_info('101',v_sonname(i),999);
  8. end loop;
  9. end ;
  10. /
  11.  
okay ,, done the change ...

Let me give u clear idea...The output parameter of above code will give me two values . Now I have sent another input parameters and the out put suppose to give me single value ..but this code give me two values (duplicate ) ..

means select son_info from emp_info where ename='leo' and empno=102;
out put is
Kun-----single value

but this above code give me two values ie
value is :Kun
value is :Kun



I wanted my code in a such away that if out put parameter return two values then it should give me two values and if it return one value then it should return a single value ... please let me know whether u have understood my question or not ..
please advice ...thanks
Mar 19 '08 #10
amitpatel66
2,367 Expert 2GB
Expand|Select|Wrap|Line Numbers
  1. Declare 
  2. v_sonname pkg.emp_name;
  3. begin 
  4. empty ('Dev',101,v_sonname);
  5. FOR I IN v_sonname.FIRST..v_sonname.LAST 
  6. LOOP
  7. insert into Emp_family_info('101',v_sonname(i),999);
  8. end loop;
  9. end ;
  10. /
  11.  
okay ,, done the change ...

Let me give u clear idea...The output parameter of above code will give me two values . Now I have sent another input parameters and the out put suppose to give me single value ..but this code give me two values (duplicate ) ..

means select son_info from emp_info where ename='leo' and empno=102;
out put is
Kun-----single value

but this above code give me two values ie
value is :Kun
value is :Kun



I wanted my code in a such away that if out put parameter return two values then it should give me two values and if it return one value then it should return a single value ... please let me know whether u have understood my question or not ..
please advice ...thanks
Check if your table contains duplicate value. It tested and it worked fine for me. It gave me only one value
Mar 19 '08 #11
orajit
75
Expand|Select|Wrap|Line Numbers
  1. CREATE OR REPLACE procedure IST.GET_CALLCLASS_TES_PRO( p_event_id number,
  2. p_acc_num varchar2,
  3. p_st_date VARCHAR2 ,
  4. p_end_date VARCHAR2 ,
  5. p_callclass out rental_spend_test.t1) as
  6.  
  7. TYPE callclass IS REF CURSOR;
  8. v_callclass callclass;
  9. sql_stmt VARCHAR2(1000);
  10. v_st VARCHAR2(1000) ;
  11. v_st1 VARCHAR2(1000);
  12. sql_stmt1 VARCHAR2(1000);
  13. BEGIN
  14. sql_stmt := 'select call_class
  15. from rest_callclass_info where EVENT_TYPE_ID= :p_event_id';
  16. OPEN v_callclass FOR sql_stmt USING p_event_id ; LOOP
  17. FETCH v_callclass INTO v_st;
  18. EXIT WHEN v_callclass %NOTFOUND;
  19. dbms_output.put_line( v_st); 
  20. sql_stmt:='SELECT '||v_st|| ' FROM rest_event where EVENT_TYPE_ID= :p_event_id and ACCOUNT_NUM=:p_acc_num and 
  21. TRUNC(CREATED_DTM) BETWEEN (:p_st_date)
  22. AND (:p_end_date)';
  23. OPEN v_callclass FOR sql_stmt USING p_event_id, p_acc_num,p_st_date,p_end_date;
  24. LOOP
  25. FETCH v_callclass bulk collect INTO p_callclass;
  26. EXIT WHEN v_callclass %NOTFOUND;
  27. --dbms_output.put_line( p_callclass);
  28. -- process record
  29. end loop;
  30. END LOOP;
  31. CLOSE v_callclass ;
  32. END;
  33. /
  34.  
  35.  


calling progm
Expand|Select|Wrap|Line Numbers
  1. DECLARE
  2. P_EVENT_ID NUMBER;
  3. P_ACC_NUM VARCHAR2(200);
  4. P_ST_DATE VARCHAR2(200);
  5. P_END_DATE VARCHAR2(200);
  6. P_CALLCLASS rental_spend_test.t1;
  7. BEGIN
  8. IST.GET_CALLCLASS_TES_PRO ( 514, 'GP00000239', TO_DATE('01022008','dd-mm-yyyy'), TO_DATE('01022008','dd-mm-yyyy'), P_CALLCLASS );
  9. FOR I IN 1..P_CALLCLASS.count
  10. LOOP
  11. DBMS_OUTPUT.PUT_LINE(P_CALLCLASS(i));
  12. end loop;
  13. END;
  14. /
  15.  
  16.  
it gives me two values


SQL> /

Ringtone
Ringtone

PL/SQL procedure successfully completed.


It suppose to give me one values ...


I wanted my code in a such away that if out put parameter return two values then it should give me two values and if it return one value then it should return a single value

cud u please tell me where I am doing mistake

I am sending you the original code ,,,please advice
Mar 19 '08 #12
amitpatel66
2,367 Expert 2GB
Could you provide me your sample data. There is some duplicate in your table that a query is fetching becuase of that.Can you check your data properly.
Mar 19 '08 #13
orajit
75
cud u please send me ur mail id i will send that data tru mail ...
Mar 19 '08 #14
amitpatel66
2,367 Expert 2GB
cud u please send me ur mail id i will send that data tru mail ...
Just Run your sql query in sql plus for the input parameters that you have passed to procedure and post only that data alone. Do not post all the table data here.
Mar 19 '08 #15
orajit
75
Insert into rest_EVENT
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 512,
'0026C6000000000', 1, TO_DATE('02/01/2008 06:23:02', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/15/2008 02:01:02', 'MM/DD/YYYY HH24:MI:SS'), 38,
899, 1, 'F', NULL, 1,
'3', NULL, '4972437130025', '0', '02011130006',
'17', '00:00:04.62', '00000000', '00000000000080', NULL,
'1', NULL, '3', NULL, '0',
NULL, NULL, NULL, NULL, NULL,
'MED1234567', 'voice', '0.0', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, '1',
'LOCAL-GEO', '1', '67', '0', '400',
'0.034 PoundSterling', NULL, NULL, NULL, NULL,
NULL, NULL, -1, 186, NULL,
NULL, NULL);
Insert into rest_event
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 512,
'0026D1000000000', 1, TO_DATE('02/01/2008 06:29:53', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/20/2008 02:01:02', 'MM/DD/YYYY HH24:MI:SS'), 38,
900, 1, 'F', NULL, 1,
'3', NULL, '4972437130025', '0', '02011130006',
'17', '00:00:04.62', '00000000', '00000000000080', NULL,
'1', NULL, '3', NULL, '0',
NULL, NULL, NULL, NULL, NULL,
'MED1234567', 'voice', '0.0', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, '1',
'LOCAL-GEO', '1', '67', '0', '400',
'0.034 PoundSterling', NULL, NULL, NULL, NULL,
NULL, NULL, -1, 186, NULL,
NULL, NULL);
Insert into rest_event (ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 513,
'0026C6000000001', 1, TO_DATE('02/01/2008 06:23:02', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/16/2008 03:01:02', 'MM/DD/YYYY HH24:MI:SS'), 0,
899, 2, 'F', NULL, 1,
'3', NULL, '4972437130025', '0', '02011130006',
'17', '00:00:04.62', '00000000', '7', NULL,
'1', NULL, '3', NULL, '0',
NULL, NULL, NULL, NULL, NULL,
'MED1234567', 'voice', '0.1', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, '32',
'FREE', '0', '67', '0', '402',
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, -1, -1, NULL,
NULL, NULL);
Insert into rest_event
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 513,
'0026D1000000001', 1, TO_DATE('02/01/2008 06:29:53', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/21/2008 03:01:02', 'MM/DD/YYYY HH24:MI:SS'), 0,
900, 2, 'F', NULL, 1,
'3', NULL, '4972437130025', '0', '02011130006',
'17', '00:00:04.62', '00000000', '7', NULL,
'1', NULL, '3', NULL, '0',
NULL, NULL, NULL, NULL, NULL,
'MED1234567', 'voice', '0.1', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, '32',
'FREE', '0', '67', '0', '402',
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, -1, -1, NULL,
NULL, NULL);
Insert into rest_event
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 514,
'0026C6000000002', 1, TO_DATE('02/01/2008 06:23:02', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/17/2008 01:04:56', 'MM/DD/YYYY HH24:MI:SS'), 0,
899, 3, 'F', NULL, 1,
'349', NULL, '9686596130021', NULL, NULL,
'0', NULL, '60', '0', NULL,
'1', NULL, NULL, 'ringbackncr', '11',
NULL, NULL, NULL, NULL, NULL,
'MED1234567', NULL, '0.2', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, '0', '402',
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, -1, 209, NULL,
NULL, NULL);
Insert into rest_event
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 514,
'0026D1000000002', 1, TO_DATE('02/01/2008 06:29:53', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/22/2008 01:04:56', 'MM/DD/YYYY HH24:MI:SS'), 0,
900, 3, 'F', NULL, 1,
'349', NULL, '9686596130021', NULL, NULL,
'0', NULL, '60', '0', NULL,
'1', NULL, NULL, 'ringbackncr', '11',
NULL, NULL, NULL, NULL, NULL,
'MED1234567', NULL, '0.2', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, '0', '402',
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, -1, 209, NULL,
NULL, NULL);
Insert into rest_event
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 515,
'0026C6000000003', 1, TO_DATE('02/01/2008 06:23:02', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/18/2008 01:04:58', 'MM/DD/YYYY HH24:MI:SS'), 3400,
899, 4, 'F', NULL, 2,
'1093', NULL, '9673307000001', NULL, '07980320251',
'6', '00:00:04.00', NULL, '0', NULL,
'32', NULL, '459', '0100000000000000000000000000000000000000', '0',
NULL, NULL, NULL, NULL, 'Reverse Charge - Xfer Chg',
'OMP1234567', '3395', '17.5.1.2.0', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, 'Evening Rate', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, -1, 24, NULL,
NULL, NULL);
Insert into rest_event
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 515,
'0026D1000000003', 1, TO_DATE('02/01/2008 06:29:53', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/23/2008 01:04:58', 'MM/DD/YYYY HH24:MI:SS'), 3400,
900, 4, 'F', NULL, 2,
'1093', NULL, '9673307000001', NULL, '07980320251',
'6', '00:00:04.00', NULL, '0', NULL,
'32', NULL, '459', '0100000000000000000000000000000000000000', '0',
NULL, NULL, NULL, NULL, 'Reverse Charge - Xfer Chg',
'OMP1234567', '3395', '17.5.1.2.0', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, 'Evening Rate', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, -1, 24, NULL,
NULL, NULL);
Insert into rest_event
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 516,
'0026C6000000004', 1, TO_DATE('02/01/2008 06:23:02', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/19/2008 02:00:00', 'MM/DD/YYYY HH24:MI:SS'), 27,
899, 5, 'F', NULL, 1,
'2198', NULL, '9673324130010', NULL, '02011130006',
NULL, '00:00:00.50', '45', '0', NULL,
'1', NULL, '1', NULL, '0',
NULL, NULL, NULL, NULL, NULL,
'OMP1234567', NULL, '6.0', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, '1',
'LOCAL-GEO', '1', '67', '0', '400',
'0.038 PoundSterling', '0.011 PoundSterling', '27.00', NULL, NULL,
NULL, NULL, -1, 216, NULL,
NULL, NULL);
Insert into rest_event
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 516,
'0026D1000000004', 1, TO_DATE('02/01/2008 06:29:53', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/24/2008 02:00:00', 'MM/DD/YYYY HH24:MI:SS'), 27,
900, 5, 'F', NULL, 1,
'2198', NULL, '9673324130010', NULL, '02011130006',
NULL, '00:00:00.50', '45', '0', NULL,
'1', NULL, '1', NULL, '0',
NULL, NULL, NULL, NULL, NULL,
'OMP1234567', NULL, '6.0', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, '1',
'LOCAL-GEO', '1', '67', '0', '400',
'0.038 PoundSterling', '0.011 PoundSterling', '27.00', NULL, NULL,
NULL, NULL, -1, 216, NULL,
NULL, NULL);
Insert into rest_event
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 517,
'0026C6000000005', 1, TO_DATE('02/01/2008 06:23:02', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/20/2008 01:20:00', 'MM/DD/YYYY HH24:MI:SS'), 85,
899, 6, 'F', NULL, 1,
'5830', '578953', '9673324130031', '0', '02920262490',
'0001', '2008/01/20-13-20-00.00', '04', '11', '000019',
'00', '10', NULL, '00:00:00.10', '10',
'0001', NULL, NULL, '0000/0000', NULL,
'MED1234567', '1510', '21.0', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, '3',
'NATIONAL-GEO', '1', '83', '0', '400',
'0.085 PoundSterling', NULL, NULL, NULL, NULL,
NULL, NULL, -1, 25, NULL,
NULL, NULL);
Insert into rest_EVENT
(ACCOUNT_NUM, EVENT_SEQ, EVENT_SOURCE, EVENT_TYPE_ID, EVENT_REF, CLUSTER_SUB_ID, CREATED_DTM, EVENT_DTM, EVENT_COST_MNY, MANAGED_FILE_ID, ROW_NUMBER, MODIFIED_BOO, COST_CENTRE_ID, TARIFF_ID, EVENT_ATTR_1, EVENT_ATTR_2, EVENT_ATTR_3, EVENT_ATTR_4, EVENT_ATTR_5, EVENT_ATTR_6, EVENT_ATTR_7, EVENT_ATTR_8, EVENT_ATTR_9, EVENT_ATTR_10, EVENT_ATTR_11, EVENT_ATTR_12, EVENT_ATTR_13, EVENT_ATTR_14, EVENT_ATTR_15, EVENT_ATTR_16, EVENT_ATTR_17, EVENT_ATTR_18, EVENT_ATTR_19, EVENT_ATTR_20, EVENT_ATTR_21, EVENT_ATTR_22, EVENT_ATTR_23, EVENT_ATTR_24, LOYALTY_POINTS, COMPETITOR_COST_MNY, INTERNAL_COST_MNY, EXTERNAL_COST_MNY, FRAGMENT_NUMBER, IMPORTED_COST_MNY, IMPORTED_CURRENCY_CODE, RATING_DISCOUNTED_USAGE_TOTAL, PRE_DISCOUNTED_COST_MNY, HIGHEST_PRIORITY_DISCOUNT_ID, TAX_OVERRIDE_ID, UST_CATEGORY_ID, UST_CODE_ID, ORIGINAL_ACCOUNT_NUM, RULE_NUMBER, EVENT_ATTR_25, EVENT_ATTR_26, EVENT_ATTR_27, EVENT_ATTR_28, EVENT_ATTR_29, EVENT_ATTR_30, EVENT_ATTR_31, EVENT_ATTR_32, EVENT_ATTR_33, EVENT_ATTR_34, EVENT_ATTR_35, EVENT_ATTR_36, HIGHEST_PRIORITY_PROD_SEQ, RECEIVABLE_CLASS_ID, REVENUE_CODE_ID, DISCOUNT_DATA, PRIMARY_EVENT_REF, INHOST_COSTED_BOO)
Values
('GP00000239', 3, '02010138199', 517,
'0026D1000000005', 1, TO_DATE('02/01/2008 06:29:53', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/25/2008 01:20:00', 'MM/DD/YYYY HH24:MI:SS'), 85,
900, 6, 'F', NULL, 1,
'5830', '578953', '9673324130031', '0', '02920262490',
'0001', '2008/01/20-13-20-00.00', '04', '11', '000019',
'00', '10', NULL, '00:00:00.10', '10',
'0001', NULL, NULL, '0000/0000', NULL,
'MED1234567', '1510', '21.0', NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, '3',
'NATIONAL-GEO', '1', '83', '0', '400',
'0.085 PoundSterling', NULL, NULL, NULL, NULL,
NULL, NULL, -1, 25, NULL,
NULL, NULL);
COMMIT;


SET DEFINE OFF;
Insert intorest_CALLCLASS_INFO
(EVENT_TYPE_ID, CALL_CLASS)
Values
(515, 'EVENT_ATTR_20');
Insert intorest_CALLCLASS_INFO
(EVENT_TYPE_ID, CALL_CLASS)
Values
(512, 'EVENT_ATTR_26');
Insert intorest_CALLCLASS_INFO
(EVENT_TYPE_ID, CALL_CLASS)
Values
(513, 'EVENT_ATTR_9');
Insert intorest_CALLCLASS_INFO
(EVENT_TYPE_ID, CALL_CLASS)
Values
(514, 'EVENT_ATTR_14');
Insert intorest_CALLCLASS_INFO
(EVENT_TYPE_ID, CALL_CLASS)
Values
(516, 'EVENT_ATTR_26');
Insert intorest_CALLCLASS_INFO
(EVENT_TYPE_ID, CALL_CLASS)
Values
(517, 'EVENT_ATTR_26');
Insert intorest_CALLCLASS_INFO
(EVENT_TYPE_ID, CALL_CLASS)
Values
(518, 'Any');
Insert intorest_CALLCLASS_INFO
(EVENT_TYPE_ID, CALL_CLASS)
Values
(519, 'Any');
COMMIT;
Mar 19 '08 #16
amitpatel66
2,367 Expert 2GB
I do not need the huge INSERT statements. Please run the SQL query in SQLPLUS that you have written in your procedure and add the input parameter values in the WHERE condition of your query and post the output here.
Mar 19 '08 #17
orajit
75
Expand|Select|Wrap|Line Numbers
  1.  
  2. select * from Rest_callclass_info
  3.  
  4.  
  5. EVENT_TYPE_ID CALL_CLASS
  6. ------------- ---------------------
  7.           515 EVENT_ATTR_20
  8.           512 EVENT_ATTR_26
  9.           513 EVENT_ATTR_9
  10.           514 EVENT_ATTR_14
  11.           516 EVENT_ATTR_26
  12.           517 EVENT_ATTR_26
  13.           518 Any
  14.           519 Any
  15.  
  16. select EVENT_TYPE_ID || ' '||EVENT_ATTR_26|| ' '||EVENT_ATTR_14|| ' '||EVENT_ATTR_20 from rest_EVENT  group by EVENT_TYPE_ID ,EVENT_ATTR_26,EVENT_ATTR_14,EVENT_ATTR_20
  17.  
  18. 514  ringbackncr
  19. 513 FREE
  20. 516 LOCAL-GEO
  21. 512 LOCAL-GEO
  22. 515  0100000000000000000000000000000000000000 Reverse Charge - Xfer Chg
  23. 517 NATIONAL-GEO 00:00:00.10
  24.  
  25.  
Mar 24 '08 #18
amitpatel66
2,367 Expert 2GB
Expand|Select|Wrap|Line Numbers
  1.  
  2. select * from Rest_callclass_info
  3.  
  4.  
  5. EVENT_TYPE_ID CALL_CLASS
  6. ------------- ---------------------
  7.           515 EVENT_ATTR_20
  8.           512 EVENT_ATTR_26
  9.           513 EVENT_ATTR_9
  10.           514 EVENT_ATTR_14
  11.           516 EVENT_ATTR_26
  12.           517 EVENT_ATTR_26
  13.           518 Any
  14.           519 Any
  15.  
  16. select EVENT_TYPE_ID || ' '||EVENT_ATTR_26|| ' '||EVENT_ATTR_14|| ' '||EVENT_ATTR_20 from rest_EVENT  group by EVENT_TYPE_ID ,EVENT_ATTR_26,EVENT_ATTR_14,EVENT_ATTR_20
  17.  
  18. 514  ringbackncr
  19. 513 FREE
  20. 516 LOCAL-GEO
  21. 512 LOCAL-GEO
  22. 515  0100000000000000000000000000000000000000 Reverse Charge - Xfer Chg
  23. 517 NATIONAL-GEO 00:00:00.10
  24.  
  25.  
Please POST the output of the below query:

Expand|Select|Wrap|Line Numbers
  1.  
  2. SELECT event_type_id,EVENT_ATTR_14,ACCOUNT_NUM,TRUNC(CREATED_DTM) FROM rest_event where EVENT_TYPE_ID= 514 and ACCOUNT_NUM='GP00000239' and 
  3. TRUNC(CREATED_DTM) BETWEEN TO_DATE('01022008','dd-mm-yyyy')
  4. AND TO_DATE('01022008','dd-mm-yyyy')
  5.  
  6.  
Mar 24 '08 #19

Sign in to post your reply or Sign up for a free account.

Similar topics

3
Getting Return Value of Stored Procedure
by: Vipul Pathak | last post by:
Hello Friends ! I have the Following Code, that Executes a Stored Procedure and Attempt to read a Returned Integer Value from the StoredProc. But It gives Error ... ADODB.Command (0x800A0BB9)...
ASP / Active Server Pages
7
ASP / Stored Procedure SQL Insert Help
by: Bill Kellaway | last post by:
Hi there - this should be fairly simple for someone. Basically I can't figure out how to pass the parameters from ASP to a Stored Procedure on SQL. Here's my code: I just need to help in...
ASP / Active Server Pages
0
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET
by: Nashat Wanly | last post by:
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET View products that this article applies to. This article was previously published under Q310070 For a Microsoft...
Microsoft SQL Server
5
Informix "foreach execute procedure": converting to DB2
by: Gustavo Randich | last post by:
Hello, I'm writing an automatic SQL parser and translator from Informix to DB2. Now I'm faced with one of the most difficult things to translate, the "foreach execute procedure" functionality...
DB2 Database
2
run stored procedure
by: Dino L. | last post by:
How can I run stored procedure (MSSQL) ?
C# / C Sharp
4
SQL Server Stored Procedure with Output Parameter and ASP.NET SQLCommand
by: Mr Not So Know It All | last post by:
im new to SQL Server and ASP.Net. Here's my problem. I have this SQL Server stored procedure with an input parameter and output parameter CREATE PROCEDURE . @in_rc varchar(8) @out_eList...
ASP.NET
9
How to build a procedure that returns different numbers of columns as a result based on a parameter
by: serge | last post by:
/* Subject: How to build a procedure that returns different numbers of columns as a result based on a parameter. You can copy/paste this whole post in SQL Query Analyzer or Management Studio...
Microsoft SQL Server
9
Stored Procedure and SQLCommand
by: fniles | last post by:
I am using VB.NET 2003 and SQL2000 database. I have a stored procedure called "INSERT_INTO_MYTABLE" that accepts 1 parameter (varchar(10)) and returns the identity column value from that table....
Visual Basic .NET
3
Stored Procedure to reliably update two tables.
by: stockton | last post by:
I have written the following Stored Procedure in an attempt to update two tables in the same database reliably but unfortunately it is not too successful. I ocassionaly end up with only the...
Microsoft SQL Server
1
Stored procedure incorrect?
by: stockton | last post by:
I have written the following Stored Procedure and need input as to what could be wrong with my coding or is there a possibility that not getting the correct results is not in the procedure at all? ...
Microsoft SQL Server
0
Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
General
0
Basic Javascript concepts
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
Javascript
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!