Search results for query: *

I was browsing the web the other day and a website I had a look at redirected you to a different webpage but still preserved the original URL that was typed in the address bar on the browser (it didn't move or change at all) How is that possible? I would like to do something similar. The reason...

Hi I have spent most of the week trying to get the whole thing working. I have got bits working eg , its created the table if I replace the I_id with an actual number in the loop. My manager will kill me if I spend any more time on it. I am not really a programmer but usually I can pick code...

Jee, thank you for your reply, I changed the line to this l_stmt := l_stmt || 'subid' || TO_CHAR(i) ||' '||'varchar(20) ,'; but stil get this error , strange as I thought that must be it! I am just running this code interactivaly and not in a procedure, thats ok isnt it? ORA-06502...

Hi, I have sorted some problems out but I am tuck on this one. I have marked line 13 with a *. The data in custin table are all integer. ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 13 ================================================== declare l_stmt...

magic, thanks it was the second end; that did it! thank you all again . I have some other problems with it now but will try and sort it out myself first. thanks again Lee

Turkbear, thank you for taking the time out to reply to my post. I have placed an end; at the bottom but I get the same error message :-) Lee

could someone give me some pointer to what is causing this error please. Error: ORA-06550: line 27, column 0: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin declare end exception exit for goto if loop mod null pragma raise return...

thanks for the info and the code. I am having a go at the code right now. I get the following error when running it. I am not a wiz at this so I need a bit of direction thanks again for taking the time out to assist me. count := count + 1; * ERROR at line 24: ORA-06550: line 24...

Sure, I agree, but this data is going to a mailing house and they require 1 customer and multiple subscriptions in one record. To tell you the truth I think someone has cocked up on the design of the datamart as you should not need to go through this hassle to meet a requirement. Regards Lee

I have a table which is in the following format CUSTID SUBID Customer1 Subscriber1 Customer1 Subscriber2 Customer1 Subscriber3 Customer1 Subscriber4 Customer2 Subscriber5 Customer2 Subscriber6 Customer3 Subscriber7 Customer3 Subscriber8 I need to transform this table into the...