SQL & PL/SQL

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!

Parsing a returned URL

786015Jul 19 2010 — edited Jul 19 2010

I am getting a URL from a vendor that I need to parst, but one of the parameters is AT and that is a resrved word in pl/sql
I am using a stored procedure to read the url and parse it.
Does anyone know a way around this. ?

The url looks like http://employee.company.com/wbhsec/ip30dev.webX_pkg.webX_backURL?siteurl=company-meetings&serviceType=MC*&AT=SM&ST=SUCCESS&MK=736176817

I tries to creTE A PROCEDURE with in parameters but it doesn't allow m,e to us AT and putting quotes around it does not help.
procedure webX_backURL
(siteurl in varchar2 default null,
serviceType in varchar2 default null,
AT in varchar2 default null,
strSearch in varchar2 default null,
strAction in varchar2 default null,
strReason in varchar2 default null,
strStatus in varchar2 default null)

any suggestions would be appreciated.
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2010

Added on Jul 19 2010

9 comments

1,069 views