Recent content by erwan

HEllo, We have a process which create the procedure. Our tables have lot of colunms that why the lines are so long. When the procedure is created, the list of column name is created on 1 line. And it's oracle which make a carriage return after about 1000 characters. And moste of the time the...

Hello, I don't have the right to copy some codes and there is no special error message . For exemple, i have : update TB35M set A00201=nd.A00201,A6470=nd.A6470, ...

I have PL/SQL procedures which are running well on Oracle 8 /Unix Aix4. It is now impossible to create/compile them on Oralce 9/Aix 5 because some lines (list of columns)od code are too long. Have you ever had this trouble? Is there parameters to change to increase the line length? Thanks for...

"" "Is it possible to create a "dynamic list of values" in a prompt whose its list depends on the selection of a previous list of values. Per exemple I have 2 prompts : Country and town. The user selects a value un "Country" (France per exemple) and when he...

Hello ! IS it Possible the to change the Character Set After Database Creation. I have been created my instance with the character set = WE8ISO8859P1 and now i want to use cyrilic character. I need to change the character set to EE8ISO8859P2. Do you think is it possible with recreating the...

Hi ! I will try that . thanks.

thanks for this infos. Erwan

Hello ! I am sorry but i don't have the solution for you. but i see that you are using BO with Citrix. Is it a good solution and is it working well. We are going to start a study on it (on december). If you are some advices about this solution they will be welcomed Thanks Erwan

Hi! Is it possible to disable the debug panel or debug button when there is an error on the report with the VBA. I just want to see the error code and message but i don't want the users see the VBA code. thanks for your help! Erwan

Hi, I want to link two reports. If the user click onto a value of the first one, i would like to open a predifined report using this value as prompt for the second one. I try to create an objet under designer using html reference. the parsing is OK, but when i want to create a report using...

In fact, i receive daily a table (185 colums and about 40000 lines). if i study this tables, 168 fields can be dimensions and only 17 fields are facts. This is a snapshot of daily information, that means, some data have changed and some have not changed, (mainly facts change,dimensions are...

I have a big table ( more than 50 0000 lignes and 185 rows). This table is store daily and i have to put then in our datawarehouse. I don't know which modele is the best way. - A star schema, with 1 table of facts and 8 tables od dimensions. - or 1 table od facts and 1 other table with all the...

Hi, Is there any trouble with SQLNET and Windows 98? I can't install it on my PC. Thank you

the only way i know to create outer joins is by the designer. You edit the join and check the outer join's checbox on the right side. Doing this, you will see a cross (+) in the expression zone. ( (+) is for Oracle). Validate your action. I never had problem doing this. Erwan

Is there any body who has a repository on security domain.