PL/SQL (MOSC)

MOSC Banner

Update via API to PO_headers

edited Apr 2, 2012 1:59AM in PL/SQL (MOSC) 5 commentsAnswered ✓
Hello all,
I am trying to update po_headers via the api po_headers_pkg_s2.  I am building this in forms 10g on an R12 database.

I'm sure the fix is easy but I cannot see it.  The data in the field is text but I need to store a number in po_headers.

I get this error: expression is of wrong type.  Meaning text in a number field or vise versa.

I am sure my coding is terrible but please be gentle.

------------------------------------------------------------------------------
  -- PROCEDURE update_docs_contact
  ------------------------------------------------------------------------------
  PROCEDURE update_docs_contact (p_header_id IN NUMBER)  IS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center