Re: Sqlplus formatting error

<andrewa1_at_rogers.com> a écrit dans le message de news: 1178292086.652062.91750_at_u30g2000hsc.googlegroups.com...
|I am running the following script from my Windows client:
|
| w.sql:
| select substr(host_name,1,15) host, substr(instance_name,1,10)
| instance, substr(global_name,1,10) DB_name,
| version, substr(user,1,10) username from v$instance, dual,
| global_name;
|
|
|
| Result:
|
| SQL> connect w/w_at_test
| Connected.
| SQL> @w;
|
| HOST INSTANCE DB_NAME VERSION
| USERNAME
| --------------- ---------- ---------- -----------------
| ----------
| sm1tordat201 test TEST 9.2.0.7.0
| W
|
|
| SQL> connect system/sebsystem_at_seblps;
| Connected.
| SQL> @w;
|
| HOST
| ------------------------------------------------------------
| INSTANCE
| ----------------------------------------
| DB_NAME
| VERSION
| ----------------------------------------
| -----------------
| USERNAME
| ----------------------------------------
| sm1tordat201
| SEBLPS
| SEBLPS
| 9.2.0.7.0
| SYSTEM
|
|
| SQL> quit
|
|
| In the first instance test, the output are formatted correctly. In the
| second instance seblps, the columns are not trimming. Does anyone know
| what's causing this? Since I'm running them both from the same Sqlplus
| session, it can't be the sqlplus settings. SELBPS and TEST both reside
| on the same unix box so the unix environment is the same. The only
| thing I can think on is the server parmeters are different but I can't
| find out which one.
|

Post "show parameter cursor_sharing" for both databases.

Regards
Michel Cadot Received on Fri May 04 2007 - 11:23:59 CDT