User Profile

ganesh raj · Mar 28 '08, 02:48 PM

Its throwing error. The error details is given below.

Error details:
declare
*
ERROR at line 1:
ORA-12899: value too large for column
"SCOTT"."EMP_MA STER"."EMP_VALU E" (actual: 10, maximum: 7)
ORA-06512: at line 13

ganesh raj · Mar 28 '08, 11:59 AM

Here a is the unique id and this should be entered by the user so Iam using this and now one more thing is that I want to update the emp_value and for the particular emp_svce_id with the result from the below query

SELECT SUBSTR(emp_svce _id,3) INTO b FROM employee_master WHERE emp_code ='PRODCD'and emp_svce_id=a;

And want to print the emp_value and emp_code; will it be possible below is what I tried.
[code=oracle]...

ganesh raj · Mar 28 '08, 10:36 AM

The mistake I did is passed 'a' instead of giving a. Thanks for guiding me...
Have a nice weekend..

ganesh raj · Mar 28 '08, 09:56 AM

This is the code Iam using in plsql where the emp_svce_id (employee service id) has to be printed which is CCDB00123. I want to cut the first two character and store DB00123 below is the script Iam trying can you please help me....
[code=oracle]

declare
a employee_master .emp_svce_id%ty pe;
b employee_master .emp_svce_id%ty pe;
begin
a:='&emp_svce_i d';
select emp_svce_id into a from employee_master...

ganesh raj · Mar 27 '08, 03:26 PM

Thanks its working now one more thing is that I have many columns and in that I want to access an single record with unique id and cut the first two letters using the number in the query is it possible.

eg:
emp_id
----------
ABssCC123

I tried the below logic but its not working...
Trim(to_char(em p_id, 'A%'),2)

ganesh raj · Mar 27 '08, 01:48 PM

I tried creating but the result does not getting updated could you please help me out.

ganesh raj · Mar 27 '08, 10:59 AM

Yes we have to store the record in log table. Please clarify me.

ganesh raj · Mar 27 '08, 08:39 AM

Thanks thats Perfect.....
Is there any way to store the rowid before updating.
Please guide me to get through the issue.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

To update a record using rowid in duplicate row.