Form designer: sample.

From: Shih-Chi Chiang <shihchic_at_wam.umd.edu>
Date: 1997/10/03
Message-ID: <34354DA4.D4505A84_at_wam.umd.edu>

This is a multi-part message in MIME format.

--------------192CF6CA27E291016157C046
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi....

When I want to run a file called "sample.fmb" in the folder c:->orawin->forms45->tutorial. This is a very simple file for tutorial of beginner.
But ther is always a generation error. So I still can't run it now. Does anyone know what's wrong with it?
This is the 1st time I install developer 2000 in my own pc.(OS:win95) Did I miss certain step in the process of installation? The message is as folowing:

Compiling procedure GET_CUSTOMER_NAME... Compilation error on procedure GET_CUSTOMER_NAME: PL/SQL ERROR 356 at line 5, column 10
'S_CUSTOMER' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling procedure GET_SALES_REP_NAME... Compilation error on procedure GET_SALES_REP_NAME: PL/SQL ERROR 356 at line 5, column 8
'S_EMP' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling procedure GET_PRODUCT_NAME...
Compilation error on procedure GET_PRODUCT_NAME: PL/SQL ERROR 356 at line 6, column 8
'S_PRODUCT' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling ON-CHECK-DELETE-MASTER trigger on ORD_BLK block... Compilation error on ON-CHECK-DELETE-MASTER trigger on ORD_BLK block: PL/SQL ERROR 356 at line 10, column 22
'S_ITEM' must name a table to which the user has access
PL/SQL ERROR 0 at line 10, column 5
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 26, column 3
SQL Statement ignored

Compiling PRE-INSERT trigger on ORD_BLK block... Compilation error on PRE-INSERT trigger on ORD_BLK block: PL/SQL ERROR 303 at line 5, column 8
qualifier 'S_ORD_ID' must be declared
PL/SQL ERROR 0 at line 1, column 1
SQL Statement ignored

Compiling PRE-QUERY trigger on ORD_BLK block... Compilation error on PRE-QUERY trigger on ORD_BLK block: PL/SQL ERROR 356 at line 5, column 22
'S_CUSTOMER' must name a table to which the user has access
PL/SQL ERROR 0 at line 5, column 7
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 22, column 4
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 28, column 10
SQL Statement ignored

Compiling POST-QUERY trigger on ORD_BLK block... Compilation error on POST-QUERY trigger on ORD_BLK block: PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored
PL/SQL ERROR 313 at line 2, column 1
'GET_SALES_REP_NAME' not declared in this scope
PL/SQL ERROR 0 at line 2, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on CUSTOMER_ID item in ORD_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on CUSTOMER_ID item in ORD_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on SALES_REP_ID item in ORD_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on SALES_REP_ID item in ORD_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling PRE-INSERT trigger on ITEM_BLK block... Compilation error on PRE-INSERT trigger on ITEM_BLK block: PL/SQL ERROR 356 at line 12, column 6
'S_ITEM' must name a table to which the user has access
PL/SQL ERROR 0 at line 1, column 1
SQL Statement ignored

Compiling POST-QUERY trigger on ITEM_BLK block... Compilation error on POST-QUERY trigger on ITEM_BLK block: PL/SQL ERROR 313 at line 1, column 1
'GET_PRODUCT_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on PRODUCT_ID item in ITEM_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on PRODUCT_ID item in ITEM_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_PRODUCT_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

--------------192CF6CA27E291016157C046
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Chiang, Shih-Chi 
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Shih-Chi  Chiang
n:              Chiang;Shih-Chi 
org:            ISR
email;internet: shihchic_at_wam.umd.edu
title:          Graduate student
tel;home:       301 935 5159

x-mozilla-cpt: ;0
x-mozilla-html: FALSE

version:        2.1
end:            vcard

--------------192CF6CA27E291016157C046-- Received on Fri Oct 03 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: ªü´ö Thenardier: "What to do with this situiation 2"
Previous message: Sylvain Faust Int'l: "Re: Using built in PL SQL Editor. Are you crazy!!"
Next in thread: Rafa Flores Yoldi: "Re: Form designer: sample."
Reply: Rafa Flores Yoldi: "Re: Form designer: sample."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message