Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL UPDATE

657009Aug 28 2008 — edited Aug 28 2008
Dear All

Below sql is my target query, but it throws some errors:

UPDATE MTP_ROUTING mtpRouting,SPLNKREM spLnkRem,SCCP_ROUTING tempSuaSpenhs ,REF_IP_PROTOCOL refIp
SET mtpRouting.TRAFFIC_TYPE_ID = refIp.ID,
mtpRouitng.SCTP_ASSOCIATION_ID = spLnkRem.SCTP_ASSOCIATION_ID
WHERE tempSuaSpenhs.LISTID = spLnkRem.SPLNKREM_ID
AND mtpRouting. ADJ_DPC = tempSuaSpenhs.DPC
AND mtpRouitng.NE = tempSuaSpenhs.NE
AND mtpRouting.NET_ID = tempSuaSpenhs.NET_ID
AND mtpRouting.TRAFFIC_TYPE_ID IS NULL
AND refIp.IP_PROTOCOL = 'SUA';


Error report:
SQL Error: ORA-00971: missing SET keyword
00971. 00000 - "missing SET keyword"

Plz help to dig out of this error.


Rgds
Prem

Comments

How can they bypass squid all together for all calls to access the website as well as direct links into the content server? Is that best done inside IIS, UCM, Squid or somewhere else?

Couple of places.

1. Expose the direct / web server url for the website / wcc instead of port 8080 one on external configuration.

2. Check in config.cfg if the webserver url parameter is set to point to 8080 or is it still showing native port.

Whoopass

Thanx. How do I do that?

Open SS Designer - On the left hand pane - system / site properties are listed .

There is a setting which shows the url setting , it is there the change has to be done.

1 person found this helpful
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2008
Added on Aug 28 2008
#general-database-discussions, #sql, #update
2 comments
444 views