$ ./account2user 123
SQL*Plus: Release 10.1.0.3.0 - Production on Fri Nov 25 11:58:22 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
old 1: select username from ods.w_single_account_image where account_id=&1
new 1: select username from ods.w_single_account_image where account_id=123
USERNAME
--------------------------------------------------
mr_foobar
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production