OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Error while executing EXEC DBMS

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Error while executing EXEC DBMS_XDB.SETHTTPPORT (Oracle 10g , windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659231]

Tue, 10 January 2017 03:23

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

https://drive.google.com/file/d/0B7Sq5KuQDDduYjI3YWtwVkpodjQ/view?usp=sharing

Hi
I am try to run apex locally on my computer. I already do this for oracle 11 g. I am configuring the embedded PL/SQL gateway for this purpose. but when i trying to execute this command :

EXEC DBMS_XDB.SETHTTPPORT(8080);

results in :

ORA-00900: invalid SQL statement

I test this code

SELECT owner, object_name, object_type, created, TIMESTAMP, status
  FROM dba_objects
 WHERE object_name = 'DBMS_XDB';

results in :
https://drive.google.com/file/d/0B7Sq5KuQDDduYjI3YWtwVkpodjQ/view?usp=sharing

[Updated on: Tue, 10 January 2017 03:28]

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659233 is a reply to message #659231]

Tue, 10 January 2017 03:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Where did you try to run

EXEC DBMS_XDB.SETHTTPPORT(8080);

Was it in SQL*Plus? TOAD? Something else?

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659235 is a reply to message #659233]

Tue, 10 January 2017 04:04

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

Hi
Thanks for your reply
I test it in Oracle Mastero , The results is the same in Pl/SQL Developer .

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659236 is a reply to message #659235]

Tue, 10 January 2017 04:11

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

Another point that when i run @apex_epg_config in sql plus , all of the commands that use dbms_xmldom.* result in error !

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659238 is a reply to message #659236]

Tue, 10 January 2017 04:49

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If it is not a problem, try to rewrite it to a standard PL/SQL block:

begin
  DBMS_XDB.SETHTTPPORT(8080);
end;
/

and/or run it in SQL*Plus.

What happens in both cases?

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659239 is a reply to message #659238]

Tue, 10 January 2017 05:04

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

Hi

when running this Code In Oracle mastero or PL/SQL Developer the Results is :

ORA-06550: line 2, column 12:
PLS-00302: component 'SETHTTPPORT' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

When running in sqlplus(After connect to it)

begin
dbms_xdb.sethttpport(8080) ;
end ;

the same results showed .

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659240 is a reply to message #659239]

Tue, 10 January 2017 05:10

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Cool. What happens when you run this query:

select count(*)
from all_objects
where object_type = 'PACKAGE'
  and object_name like 'DBMS_XDB%';

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659241 is a reply to message #659240]

Tue, 10 January 2017 06:06

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

Littlefoot wrote on Tue, 10 January 2017 14:10

Cool. What happens when you run this query:
select count(*)
from all_objects
where object_type = 'PACKAGE'
  and object_name like 'DBMS_XDB%';

Thanks for your reply

The results is :

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659242 is a reply to message #659241]

Tue, 10 January 2017 06:12

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

And the object name are : 1-DBMS_XDBZ 2-DMMS_XDB 3-DBMS_XDBZO 4-DBMS_XDBUTIL_INT . maybe usefull for you !

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659244 is a reply to message #659242]

Tue, 10 January 2017 06:58

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How did you connect to the database (which user)? If it wasn't SYS, try to connect as SYS and then run

begin
  DBMS_XDB.SETHTTPPORT(8080);
end;
/

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659245 is a reply to message #659244]

Tue, 10 January 2017 07:26

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

I Connected with sys user as sysdba .

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659247 is a reply to message #659245]

Tue, 10 January 2017 07:31

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

I see tablespace with the name XDB but in the users not see XDB user !

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659252 is a reply to message #659247]

Tue, 10 January 2017 09:44

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Are you sure that th XDB component is actually installed and valid? In my database it is:

orclz> select COMP_ID,VERSION,STATUS from dba_registry order by 1;

COMP_ID                        VERSION                        STATUS
------------------------------ ------------------------------ --------------------------------------------
APEX                           4.2.5.00.08                    VALID
APS                            12.1.0.2.0                     VALID
CATALOG                        12.1.0.2.0                     VALID
CATJAVA                        12.1.0.2.0                     VALID
CATPROC                        12.1.0.2.0                     VALID
CONTEXT                        12.1.0.2.0                     VALID
DV                             12.1.0.2.0                     VALID
JAVAVM                         12.1.0.2.0                     VALID
OLS                            12.1.0.2.0                     VALID
ORDIM                          12.1.0.2.0                     VALID
OWM                            12.1.0.2.0                     VALID
RAC                            12.1.0.2.0                     OPTION OFF
SDO                            12.1.0.2.0                     VALID
XDB                            12.1.0.2.0                     VALID
XML                            12.1.0.2.0                     VALID
XOQ                            12.1.0.2.0                     VALID

16 rows selected.

orclz>

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659257 is a reply to message #659252]

Tue, 10 January 2017 11:01

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

Hi

The Same results accure for me .

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659264 is a reply to message #659257]

Tue, 10 January 2017 13:57

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Surely not as you said you are in 10g and John is on 12c.
So use SQL*Plus and copy and paste the actual result.
Also post the result of

select * from v$version;

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659276 is a reply to message #659264]

Wed, 11 January 2017 04:36

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

Hi
Thank for your reply

Results :

BANNER                                                          
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production                          
CORE	10.1.0.2.0	Production                                      
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production         
NLSRTL Version 10.1.0.2.0 - Production

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659277 is a reply to message #659276]

Wed, 11 January 2017 04:42

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So now post the result of John's query as it is.

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659278 is a reply to message #659277]

Wed, 11 January 2017 05:02

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

COMP_ID                        VERSION                        STATUS     
AMD                            10.1.0.2.0                     VALID      
APEX                           3.2.1.00.12                    VALID     
APS                            10.1.0.2.0                     VALID      
CATALOG                        10.1.0.2.0                     VALID      
CATJAVA                        10.1.0.2.0                     VALID      
CATPROC                        10.1.0.2.0                     VALID      
CONTEXT                        10.1.0.2.0                     VALID      
EM                             10.1.0.2.0                     VALID      
EXF                            10.1.0.2.0                     VALID      
JAVAVM                         10.1.0.2.0                     VALID      
ODM                            10.1.0.2.0                     VALID      
ORDIM                          10.1.0.2.0                     VALID      
OWM                            10.1.0.2.0                     VALID      
SDO                            10.1.0.2.0                     VALID      
XDB                            10.1.0.2.0                     VALID      
XML                            10.1.0.2.0                     VALID      
XOQ                            10.1.0.2.0                     VALID

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659430 is a reply to message #659278]

Mon, 16 January 2017 13:51

Rasoul_57
Messages: 21
Registered: October 2012
Location: Iraq

Junior Member

Hi

This Problem Solved For me. when using SQL.plus the "EXEC DBMS_XDB.SETHTTPPORT(8080);" command executed successfully .

although i do not know why this command not executed successfully in oracle mastero and PL/SQL developer !!!!!!!!!!!

Thanks.

Report message to a moderator

Re: Error while executing EXEC DBMS_XDB.SETHTTPPORT [message #659432 is a reply to message #659430]

Mon, 16 January 2017 15:10

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you say so ...

Although, I just can't see why would it work, because EXEC is nothing but BEGIN - END in SQL*Plus, so these two codes:

begin
  dbms_xdb.sethttport(8080);
end;
/

and

exec dbms_xdb.sethttport(8080);

are equivalent.

Report message to a moderator

Previous Topic:	oops internet explorer could not connect to app_server:7778
Next Topic:	apex with Oracle EBS R12

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 05 10:59:02 CST 2025