Re: WOW on HP-UX; WHO WROTE IT??

In article <3u3lq3$s1n_at_sun.sirius.com>, Greg Gonzalez <gonzalez_at_sirius.com> writes:
>Hi Fred,
>
>I'm having problems too. I get:
>
>ORA-06550: line 1, column 24: PLS-00905: object GETREG is invalid
>ORA-06550: line 1, column 24: PLS-00313: 'GETREG' not declared in
>this scope ORA-06550: line 1, column 24: PL/SQL: Statement ignored
>ORA-06550: line 1, column 42: PLS-00201: identifier
>'WOW.GET_PAGE' must be declared ORA-06550: line 1, column 38:
>PL/SQL: Statement ignored
>

WOW.GET_PAGE is a PL/SQL procedure you load from wow.sql.

you probably loaded WOW.GET_PAGE and GETREG (get_reg?) into one schema and are now trying to execute them from another. for example, you loaded these procedures as SYS but are now WOW_USER in your wow script.

have you executed this procedure by hand using the WOW_UID and sqlplus? (WOW_UID is the name/password combination you've chosen for wow)

	sqlplus $WOW_UID
	> set serveroutput on
	> exec getreg;

oh yeah, wow/wowstub written by M. Lonnroth, Oracle Corp. in my dealings with hime, he seems like a nice guy who knows what he's talking about.

//michael

-- 
:: michael ryan , ryan_at_xsoft.xerox.com
:: ob disclaimer: opinions expressed are not those of xerox, corp.