Here is the SQL for the Query, is there something in this that might be
causing the problem?

SELECT ORGANIZATI AS MEDIAOUTLET
, CONTACT AS REPORTER
, NEWS_PHONE as PHONE
, TARGET_CIT as TARGETCITY
, EMAIL
, TYPECOL as MEDIATYPE
, ADDRESS
, CITY
, STATE
, ZIP
, AREA___MAI
, AREA___NEW
, AREA_CODE
, MAIN_PHONE
, AREA_MAINF
, AREA_NEWSF
, FAX_AREA
, MAIN_FAX
, NEWS_FAX
, MEDIAID
FROM MEDIA
WHERE MEDIAID = ?pMEDIAID


UPDATE MEDIA SET
MEDIAID = :MEDIAID,
TARGET_CIT = :TARGET_CIT,
CONTACT = :CONTACT,
ORGANIZATI = :ORGANIZATI,
ADDRESS = :ADDRESS,
CITY = :CITY,
STATE = :STATE,
ZIP = :ZIP,
AREA___MAI = :AREA___MAI,
AREA___NEW = :AREA___NEW,
AREA_CODE = :AREA_CODE,
MAIN_PHONE = :MAIN_PHONE,
NEWS_PHONE = :NEWS_PHONE,
AREA_MAINF = :AREA_MAINF,
AREA_NEWSF = :AREA_NEWSF,
FAX_AREA = :FAX_AREA,
MAIN_FAX = :MAIN_FAX,
NEWS_FAX = :NEWS_FAX,
EMAIL = :EMAIL,
TYPECOL = :TYPECOL
WHERE
MEDIAID = :OLD.MEDIAID

INSERT INTO MEDIA(
MEDIAID,
TARGET_CIT,
CONTACT,
ORGANIZATI,
ADDRESS,
CITY,
STATE,
ZIP,
AREA___MAI,
AREA___NEW,
AREA_CODE,
MAIN_PHONE,
NEWS_PHONE,
AREA_MAINF,
AREA_NEWSF,
FAX_AREA,
MAIN_FAX,
NEWS_FAX,
EMAIL,
TYPECOL)
VALUES (
:MEDIAID,
:TARGET_CIT,
:CONTACT,
:ORGANIZATI,
:ADDRESS,
:CITY,
:STATE,
:ZIP,
:AREA___MAI,
:AREA___NEW,
:AREA_CODE,
:MAIN_PHONE,
:NEWS_PHONE,
:AREA_MAINF,
:AREA_NEWSF,
:FAX_AREA,
:MAIN_FAX,
:NEWS_FAX,
:EMAIL,
:TYPECOL)