Yii Framework Forum: Error db - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Error db Rate Topic: -----

#1 User is offline   kitty10 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 139
  • Joined: 13-April 10

Posted 27 April 2010 - 04:48 AM

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 20999 OCIStmtExecute: ORA-20999: TAPI-1005:Violata chiave esterna DOCENTE_FACOLTA_FK della tabella DOCENTE
ORA-06512: at "ORA02.CG$ERRORS", line 86
ORA-06512: at "ORA02.CG$DOCENTE", line 207
ORA-06512: at "ORA02.CG$AIS_DOCENTE", line 49
ORA-04088: error during execution of trigger 'ORA02.CG$AIS_DOCENTE'
(ext\pdo_oci\oci_statement.c:146)INSERT INTO docente (LABORATORIO, MATRICOLA, FACOLTA_FACOLTA_ID, DIPART_DIPART_ID, DATA_ASSUNZIONE, FASCIA_DOCENTE, DATA_NOMINA, DATA_CONFERMA, DATA_FINE, NOTE, CARRIERA, BACKGROUND, RICONOSCIMENTI, HONORS, CONVEGNI, CONFERENCE, ASSOCIAZIONI, MEMBERSHIP, TITOLI, EDUCATION, RICERCA, RESEARCH, FINANZ_CAP_EURO, FINANZ_CC_EURO, RICHIESTO_FINANZ, SUCCESSO_FINANZ, PUNTEGGIO_VPS, ANNO_VPS, INTERESSI_GENERALI, SCIENTIFIC_INTERESTS, URL, RICEVIMENTO, S_S_D_S_S_D_ID, INDENNITA_SANITARIA, ANAGRA_ANAGRA_ID, RUOLO) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35) RETURNING MATRICOLA INTO :RETURN_ID

Can you help me????
-1

#2 User is offline   Maurizio Domba Cerin 

  • Yii - Yesss It Is !!!
  • Yii
  • Group: Yii Dev Team
  • Posts: 4,317
  • Joined: 12-October 09
  • Location:Croatia

Posted 27 April 2010 - 05:22 AM

As it says "Violata chiave esterna DOCENTE_FACOLTA_FK della tabella DOCENTE" I presume that the FACOLTA_FACOLTA_ID that you want to insert in the table docente does not exist in the table FACOLTA...
Find more about me.... btw. Do you know your WAN IP?
0

#3 User is offline   kitty10 

  • Standard Member
  • PipPip
  • Yii
  • Group: Members
  • Posts: 139
  • Joined: 13-April 10

Posted 27 April 2010 - 05:46 AM

View Postmdomba, on 27 April 2010 - 05:22 AM, said:

As it says "Violata chiave esterna DOCENTE_FACOLTA_FK della tabella DOCENTE" I presume that the FACOLTA_FACOLTA_ID that you want to inset in the table docente does not exist in the table FACOLTA...


yes i have set in the function relation the foreign key FACOLTA_FACOLTA_ID and now works
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users