السلام عليكم يا اخوانى
اريد منك المساعده فى عملية انشاء كلاس فى ال PL/SQL
توجد معى package انا عملتها عندما احاول ان شاء ال function
يطلع لى خطاء وهو ان ال package حقى مش موجوده الرجاء المساعده فى الحل


CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "MyApplication" AS
import edu.sz.ie.*;
import edu.sz.ie.bw.*;
import java.util.List;
import java.io.IOException;

هنا باقى الكود عادى مافى مشكله

هناا نلاحظ ان

edu.sz.ie.*;
edu.sz.ie.bw.*;
هذول ال package تبعى

بالنسبة لل
import java.util.List;
import java.io.IOException مافى مشكله

السوال كيف اصيفى ال package الى اوراكل
او هناك طريقه معينة

you import another package that should be loaded in java classes

import edu.sz.ie.*;
import edu.sz.ie.bw.*;

You should load java classes before compile your Java Source

use below link which would guide you to load java classes

http://docs.oracle.com/cd/B10501_01/java.920/a96659/02_load.htm

you import another package that should be loaded in java classes

import edu.sz.ie.*;
import edu.sz.ie.bw.*;

You should load java classes before compile your Java Source

use below link which would guide you to load java classes

http://docs.oracle.c...659/02_load.htm

الف شكر اخى و لكن عندما اقوم بتحميل الكلاس الى داخل اوراكل
كيف استطيع ان اعمل
import edu.sz.ie.*;

اى ان الكلاس ليس دخل package
كماهو فى هذا الامر
import edu.sz.ie.*;
هل اكتب فقط
import follow by class name

وشكرا

تم تعديل 8 أبريل 201213 سنة بواسطة wael200516

Every class may have package name like edu.sz.ie , so when you import class oracle internal know the package name in class

At general if you import class with package names then you must import using package name, otherwise if you import class with class only the you must import by class name only because he hasn't package

Note package name is written in class code

Every class may have package name like edu.sz.ie , so when you import class oracle internal know the package name in class

At general if you import class with package names then you must import using package name, otherwise if you import class with class only the you must import by class name only because he hasn't package

Note package name is written in class code

Many thanks brother

Every class may have package name like edu.sz.ie , so when you import class oracle internal know the package name in class

At general if you import class with package names then you must import using package name, otherwise if you import class with class only the you must import by class name only because he hasn't package

Note package name is written in class code

Many thanks brother

Thanks Wael about your appreciation , I will post new article about using java in PLSQL nearly

Many thanks dear Mahoud

Please see this question

http://www.araboug.org/ib/index.php?showtopic=49648