pen-test
[Top] [All Lists]

Re: Oracle Application Server 10g question

To: Lee Lawson <leejlawson@gmail.com>
Subject: Re: Oracle Application Server 10g question
From: Joxean Koret <joxeankoret@yahoo.es>
Date: Wed, 14 Mar 2007 22:26:03 +0100
Cc: PenTest <pen-test@securityfocus.com>
Delivered-to: sp-com-lists@consult.net
Delivered-to: pentest-list2@consult.net
Delivered-to: mailing list pen-test@securityfocus.com
Delivered-to: moderator for pen-test@securityfocus.com
Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.es; h=Received:X-YMail-OSG:Subject:From:To:Cc:In-Reply-To:References:Content-Type:Date:Message-Id:Mime-Version:X-Mailer; b=zF4si79Q3EBgER5ifJbm1qttrf9+FMpZD9YcxOW4Ajj6EkzN6pz4koczw80hsI+F/cQpdtsuuGystWJiCJjgR57ZOSiNWy1b+iFS9Q+5r+yUL2ymIxE2SWk/T8y6njW2mJxLHbG21ThKQ1DFYJwEBmvNDUTtKLZJ7kbgucpmYwk= ;
In-reply-to: <3286d67f0703140308n53499d5ct48a8e947709ca5ff@mail.gmail.com>
List-help: <mailto:pen-test-help@securityfocus.com>
List-id: <pen-test.list-id.securityfocus.com>
List-post: <mailto:pen-test@securityfocus.com>
List-subscribe: <mailto:pen-test-subscribe@securityfocus.com>
List-unsubscribe: <mailto:pen-test-unsubscribe@securityfocus.com>
Mailing-list: contact pen-test-help@securityfocus.com; run by ezmlm
References: <3286d67f0703140308n53499d5ct48a8e947709ca5ff@mail.gmail.com>
Resent-date: Sun, 18 Mar 2007 01:02:12 -0700 (MST)
Resent-from: pen-test-return-1078483790@securityfocus.com
Resent-message-id: <20070318080212.9A596237AD4@outgoing3.securityfocus.com>
Resent-sender: listbounce@securityfocus.com
Sender: listbounce@securityfocus.com
Hi Lee,

On mié, 2007-03-14 at 10:08 +0000, Lee Lawson wrote:
> 
> Consider the following URL:
> http://target.com/portal/page?_pageid=270,34&_dad=portal&_schema=PROTOCOL
> 
> This is the home page.  If I replace the _pageid= value with a single
> quote, I am presented with the following error on the web page.
> Error: ORA-06502: PL/SQL: numeric or value error: character to number
> conversion error 

That's not SQL injection. If you receive messages like these while
pen-testing an Oracle Application Server's app ignore. You should check
for messages like ORA-00933, ORA-01756 or ORA-00923 (Unclosed quotation
mark, etc...). 

Ah! An check for any message starting with "PLS-". That kind of messages
are generated by badly composed sql commands. In Example, the following
bad SQL command:

BEGIN
  OWNER.PACKAGE([INJECTED &
MORE INJECTED DATA]
);
END;

Will generate a PLS-00103 error message. You should also check for
ORA-00604 messages ( Error ocurred at SQL recursive ), ORA-00942 (table
or view does not exists) and ORA-03113 (End of file on communication
channels) or ORA-00600 (internal error), but the 2 last are very-very
strange to find.

Hope that helps.

Regards,
Joxean Koret

Attachment: signature.asc
Description: This is a digitally signed message part

<Prev in Thread] Current Thread [Next in Thread>