error in executing procedure [message #294270] |
Thu, 17 January 2008 00:49  |
dmerin
Messages: 30 Registered: December 2007
|
Member |
|
|
Hi,
Please go through the attachment
I was able to succcessfully compile the procedure
but when i tried to execute using command
exec porc name
its showing following error:
ERROR at line 1:
ORA-00979: not a GROUP BY expression
ORA-06512: at "APPS.ORDER_DET_INSERT", line 12
ORA-06512: at line 1
Please help me out
-
Attachment: insert.txt
(Size: 0.70KB, Downloaded 486 times)
|
|
|
|
Re: error in executing procedure [message #294277 is a reply to message #294270] |
Thu, 17 January 2008 01:16   |
shankar muthusamy
Messages: 21 Registered: November 2006 Location: singapore
|
Junior Member |
|
|
Hi
select 'OD'||TO_CHAR(LPAD(NVL(MAX(SUBSTR(order_det_id,3)),0)+1,3,0)) ORDER_DET_ID,
xxtro_orders.order_ID ORDER_ID,'P'||TO_CHAR(LPAD(NVL(MAX(SUBSTR(order_det_id,3)),0)+1,3,0)) PRODUCT_ID,
quantity+5,rate+2,quantity*rate
FROM xxtro_orders,order_details where xxtro_orders.order_id=c_order
GROUP BY xxtro_orders.ORDER_ID;
In the above query, group by based on order_id what about quantity,rate - Try to execute the query in Sql you can feel it.
Regards
Shankar.M
|
|
|
|
|
|